Forum Discussion

ppgandhi11's avatar
ppgandhi11
Helper V
7 years ago
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 ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    ppgandhi11 try following

     

    Measure Val =
VAL myCalculation = SUM( Table1[Amount]) -- put your measure calculation here
RETURN
 IF( myCalculation = BLANK(), "N/A", myCalculation)
S184019's avatar
S184019
Advocate III
7 years ago

ppgandhi11

 

Perhaps this can be resolved before it becomes tabular.  If in the query editor, the field exists with zeros (or blanks), then it should be possible to convert the field to text and do replace blanks (or zeros) with n/a's.