Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Replacing blanks with 0 in matrix visual

Hi,    I currently have this matrix with many blanks in dates where there are no values. The original data does not display zero, so I am trying to find a way to change the blanks in this visual to...
Need Help
Tips and Tricks
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Anonymous , In this case you could use below formula. 

    Measure = calculate(count(table[name]))+0
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, 

 

The issue is that my original data does not contain the missing values. It skips over those. I tried the above measures but it displays all the names instead of counting them. This is how it is currently organized: 

 

I would go to the original data and trasnform the values to zero, but not all days have values for each location in the source data. 

 

Thank you for any help!  

 

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous , In this case you could use below formula. 

Measure = calculate(count(table[name]))+0
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Samarth_18 

     

    I tried that measure but this was my output: 

     

    Edit: This works! I will just change the name of the Measure Column, thank you!