Forum Discussion
Solved
Data formatting question - Desktop
Hi, I have a measure that brings values for some of the records. So wherever it is applicable, it brings correct values. At other rows, it remains blank because it is not applicable there. I ...
ppgandhi11 try following
Measure Val = VAL myCalculation = SUM( Table1[Amount]) -- put your measure calculation here RETURN IF( myCalculation = BLANK(), "N/A", myCalculation)
ppgandhi11 try following
Measure Val = VAL myCalculation = SUM( Table1[Amount]) -- put your measure calculation here RETURN IF( myCalculation = BLANK(), "N/A", myCalculation)
ah, that works!
you meant var not val in 2nd line, but i got it working! Thanks a lot!