Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 ?

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

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