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)
dedelman_clng's avatar
dedelman_clng
Community Champion
7 years ago

You can, but then you lose the formatting capability a measure being a number.

 

MeasureOrNA = 
  var __MyMeasure = [Measure Calculation here]
  return
  IF ( ISBLANK( __MyMeasure), "N/A", __MyMeasure )

You may be able to use the FORMAT function (FORMAT( __MyMeasure, "Percent") to make it look like a percentage.

 

 

Hope this helps,

David