Forum Discussion
Show Measure for missing data point in dax
Hi, I have a fact table with data but not for all data points in calendar table, when i trow data into matrix it shows blanks when there is no corresponding value - which is ok, but i'm trying to...
mhsk I can only speculate that your other measure is also returning blank. You can confirm this by creating a measure ReturnZero = 0 and then this:
ReplaceBlank = IF( ISBLANK(MyOtherCalc), ReturnZero, MyOtherCalc )
That should also return 0.