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...
Your 2nd measure is missing the ) after the +0. But why can't you just use this expression?
NewMeasure = COUNT('FT-cal-acad-faculty only'[Faculty Rank]])+0
Regards,
Pat
Its giving me the error 'A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed'
When i posted before, someone told me to create a separate table and then use it in this measure. here's the table i created (called Replacing 0's) which I reference at the end of the measure you corrected for me :
I'm not sure if this separate table is needed and if I can just use a measure referencing my main dataset (i.e. is there a way to not use the 'Replacing 0's table)?