Forum Discussion

AndrewPF's avatar
AndrewPF
Icon for Helper V rankHelper V
3 years ago

adding zero values to a matrix heatmap

I have created a heatmap from a matrix:      but I want the squares without values to have zeroes.    Is there any way of accomplishing this, other than adding "zero" rows into my test dat...
Need Help
AndrewPF's avatar
AndrewPF
Icon for Helper V rankHelper V
3 years ago

I don't think I understand.  I don't have any rows in my data where, for example, Impact = "4 - Likely" and Likelihood = "4 - Severe".  The values are just COUNT = 1 on each row in the source data and I am summing them in the matrix with Impact as the X-axis and Likelihood as the Y-axis.  Creating a new [COUNT] + 0 measure won't create any values where there are no existing values. 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

AndrewPF Create a measure:

 

Measure = SUM('Table'[COUNT]) + 0

For the blank areas, the sum will return BLANK and then when 0 is added, you get 0. Adding zero to sums that return numbers (not blank) does not change the number.