Display 0 on card when 4 our of 6 filters are used

[Jolita_And]

I have a number displayed in card and I want it to change only based on 2 filters out of 6. I want it to automatically convert to 0 when other 4 filters are being used (for example to make it dependent on month, but when I choose country it turns to 0). Is it somehow possible? Thanks!

[v-eachen-msft · Accepted solution]

Hi @Jolita_And ,

You could create a measure to do it.

Measure =
IF ( ISFILTERED ( 'Table'[Column3] ), 0, SUM ( 'Table'[Value] ) )

Here is my test file for your reference.

[amitchandak]

Try using isfiltered

https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601