Default Value 0

[dw700d]

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?

[Ahmedx · Accepted solution]

look at this
https://www.youtube.com/watch?v=sXn-QZqLD-8&ab_channel=GuyinaCube

[v-zhangti · Accepted solution]

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.

[Ahmedx · Accepted solution]

look at this
https://www.youtube.com/watch?v=sXn-QZqLD-8&ab_channel=GuyinaCube