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

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

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