Events
Sep 15, 6 AM - Sep 17, 3 PM
The best Power BI community-led event. Sept 2025. Use code FABLEARN to save €200.
Get registeredNote
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE.
DAX
HASONEFILTER(<columnName>)
| Term | Definition |
|---|---|
columnName |
The name of an existing column, using standard DAX syntax. It cannot be an expression. |
TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE.
This function is similar to HASONEVALUE() with the difference that HASONEVALUE() works based on cross-filters while HASONEFILTER() works by a direct filter.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following example shows how to use HASONEFILTER() to return the filter for ResellerSales_USD[ProductKey]) if there is one filter, or to return BLANK if there are no filters or more than one filter on ResellerSales_USD[ProductKey]).
DAX
= IF(HASONEFILTER(ResellerSales_USD[ProductKey]),FILTERS(ResellerSales_USD[ProductKey]),BLANK())