Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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.
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