Forum Discussion
Default Value 0
I have card visuals that show the total amount of toys, cars, cats and houses. I am slicing this data by date. if a date is not selected in the slicer I would like the default value of the card visual to be 0. If a date is selected then the appropriate filtering should flow through. Is there a measure that can help me accomplish this?
Hi, dw700d
You can try the following methods.
Sample data:SUM = SUM('Table'[Value])Measure = IF(ISFILTERED('Table'[Date]),[SUM],0)Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, dw700d
You can try the following methods.
Sample data:SUM = SUM('Table'[Value])Measure = IF(ISFILTERED('Table'[Date]),[SUM],0)Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.