Forum Discussion

vipinverma11's avatar
vipinverma11
Frequent Visitor
3 years ago

Matrix visual help, blank to zero

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

 

Need Help

3 Replies

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    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's avatar
      AdaVFR
      Regular Visitor
      3 years ago

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

  • olgad's avatar
    olgad
    Resident Rockstar
    2 years ago

    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!