Using ISFILTERED() Function

[Anonymous]

I have some page level filters for a category in my power BI project and when I use the "ISFILTERED()" function in the dashboard for the same category, it always returns true but, I don't want my "ISFILTERED()" function to be affected by the page level filter rather I want it to return FALSE, if I don't select anything on the slicer and returns TRUE only if I select some element in the slicer.

Can anyone tell me how to do this or, any alternative of "ISFILTERED()" that I can use. In this case.

Let me know if you need any additional information  about the question.

[Anonymous]

as you have applied filtered at page level it will alwasys returns  TRUE.

You can try below dax.

Assume Your column have 6 values and you have added it in slicer and you have set 1 value in page level filter.

if(isfiltered(column) && distinctcount(column)>1 ,1,0)

Thanks & regards,

Pravin Wattamwar

If it resolved your problem mark it as solution and give kudos.