Matrix visual help, blank to zero

[vipinverma11]

Hi , 

I have a table like this which is calculating distinct count of date , like on which day test perform so it will take count of that day.

But the issue is like if particular station name doesn't have any value it will not show in visual , i want to show that station name as well with the value of Zero. to identify that station is not running on that particular year or month

Or where ever blank is there i want to show that zero as well

[olgad]

@vipinverma11 Have my answer or you yourself solved your problem? If so, can you please share your solution or accept my answer as Solution to help other members find it faster? Thank you very much for your kind cooperation!

[olgad]

Hi, in your measure please add !
+0 in the end.
For example; Calculate(Sum(Sales)) +0

It shall work if you are using a separate dimension table for your dates.

[AdaVFR]

Thats a trick i was looking for, thanks a million.