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 ...
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.