HASONEFILTER in DAX??

[Anonymous]

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

[Stachu]

quoting https://msdn.microsoft.com/en-us/query-bi/dax/hasonefilter-function-dax

Remarks

1. This function is similar to HASONEVALUE() with the difference that HASONEVALUE() works based on cross-filters while HASONEFILTER() works by a direct filter.

[Anonymous]

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]

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 · Accepted 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