Forum Discussion
Make empty data points show up as zero
HI Anonymous,
I'd like to suggest you confirm if these empty data did not really exist in your tables first. For this scenario, these empty data are expanded by the current category combo and you can't direct replace these values.
You need to extract category value as a new table and use this on your visual, then write measure formula to lookup value based on raw table category and new table value, replace the not matched parts with zero records.
Replacing null values in matrix visual
Regards,
Xiaoxin Sheng
Hello Anonymous,
It won't work in this case since the answers are rows, and if no one answered "Disagree" then this row simply does not exist in the table for a specific question, therefore I wouldn't be able to replace it. What I can try to do is to create a column that counts the answers for each question and then replace those values. Maybe that should work.
Measure =
VAR __MyCalc = <some calc>
RETURN
IF(ISBLANK(__MyCalc),0,__MyCalc)
You might also need to check for = ""