Current Measure to show "N/A" instead of blank

[vjnvinod]

Dear all,

i am using the below measure & which is correct, the only thing i would like to show, if values are blank, then show that "N/A"

EU Current Month - 2% Actual =

CALCULATE (

DIVIDE (

SUM ( 'People Flash Consolidated'[Chargeable Hours - Actual] ),

SUM ( 'People Flash Consolidated'[Effective Available Hours - Actual] )

),

'People Flash Consolidated'[Period] = "MTD",

'People Flash Consolidated'[3 M Weightage] = TRUE

)

How do i tweak this measure to give me a result which is "n/a" if the value is blank?

[Anonymous · Accepted solution]

Hello @vjnvinod 

You can try the below code.

EU Current Month - 2% Actual =
VAR TotalHours =
CALCULATE (
DIVIDE (
SUM ( 'People Flash Consolidated'[Chargeable Hours - Actual] ),
SUM ( 'People Flash Consolidated'[Effective Available Hours - Actual] )
),
'People Flash Consolidated'[Period] = "MTD",
'People Flash Consolidated'[3 M Weightage] = TRUE
)
RETURN
IF( ISBLANK( TotalHours ), "N/A", TotalHours )