Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Here by '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?
Or do we have any other type of filteration ?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |