Forum Discussion

elopez's avatar
elopez
Icon for Helper I rankHelper I
5 years ago

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...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

try

 

measure =
IF (
    ISBLANK ( COUNT ( 'FT-cal-acad-faculty only'[Faculty Rank] ) ),
    0,
    COUNT ( 'FT-cal-acad-faculty only'[Faculty Rank] )
)

  • elopez's avatar
    elopez
    Icon for Helper I rankHelper I
    5 years ago

    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)