check if a table is filtered but exclude one field

[MikeSolvesBI]

Hello,

I am using IsFiltered for a table call Customers.

What I want to do is check if the Customers table is Filtered but exclude if the field Status is filtered.

IsCustomerFiltered = IsFiltered(Customers,AllExcept(Customers,Status)). 

This does not work.

Is there a workaround,

Thank You,

Michael

[Greg_Deckler · Accepted solution]

@MikeSolvesBI Perhaps:

IsCustomerFiltered = ISFILTERED('Customers') && NOT(ISFILTERED('Customers'[Status]))

[MikeSolvesBI]

Hello,

I guess I should have been clearer.

The Status is a page filter and is always on.   I want to ignore the page filter.

Sorry,

Michael

[feelthelight14]

Hi @MikeSolvesBI ,

have you found a solution for this case?

I will really appreciate your answer! 🙂