Forum Discussion
Replacing missing values in matrix table with '0'
I am making quite a few matrix tables similar to the one below. I want to replace the blank fields with '0'. However, when I try to use different calculated measures, nothing happens or I get an erro...
try
measure =
IF (
ISBLANK ( COUNT ( 'FT-cal-acad-faculty only'[Faculty Rank] ) ),
0,
COUNT ( 'FT-cal-acad-faculty only'[Faculty Rank] )
)
It didn't do anything, same as my option 1. it just again displays the same values without replacing any blank fields with '0' (i get the exact same table as in the picture above, with blank fields)