Forum Discussion
HASONEFILTER in DAX??
Can someone tell me what Exactly is HASONEFILTER() does in DAX? I know I can search in internet and learn from there which i tried but this function does not seem to be going in my head?
Can anyone explain this DAX f(x) with some demo example.
Regards,
Droid
Hi Anonymous
Here 'Filter' are we referring to any type of filter whether it be a visual level filter, page level filter, report level or even a slicer.
Look at my test
add the following measure in a card visual without any filter
filter = IF(HASONEFILTER(Sheet3[stage name]),TRUE(),FALSE())
Then add a visual level filter and select an item
Then add a slicer and select an item
Best Regards
maggie
4 Replies
H Anonymous
Say for example, country table has 2 filters applied, Category table has one filter applied, Sales table has no filter. Then
HASONEFILTER(Country) returns FALSE
HASONEFILTER(Category) returns TRUE
HASONEFILTER(Sales) returns FALSE
Which means , if the table/column has only one filter , then this function returns true. Hope this helps.
Thanks
Raj
Hi Anonymous
Here 'Filter' are we referring to any type of filter whether it be a visual level filter, page level filter, report level or even a slicer.
Look at my test
add the following measure in a card visual without any filter
filter = IF(HASONEFILTER(Sheet3[stage name]),TRUE(),FALSE())
Then add a visual level filter and select an item
Then add a slicer and select an item
Best Regards
maggie
quoting https://msdn.microsoft.com/en-us/query-bi/dax/hasonefilter-function-dax
Remarks
- This function is similar to HASONEVALUE() with the difference that HASONEVALUE() works based on cross-filters while HASONEFILTER() works by a direct filter.
