Using message N/A instead of BLANK

[Anonymous]

Hi all, 

I am making a report , that contains 4-5 slicers, i want to ask one thing that whenever I make selections from the slicer then the corresponding results appears on my dashboard, but sometimes when the relevant data is not present, it shows BLANK, but I want N/A instead of BLANK, how to go ahead with this ?

Can somebody please help ?
Thanks !

[Anonymous]

Create a new measure based on the one you have:

[New Meas] = COALESCE( [Old Meas], "N/A")

Best
D

[Anonymous]

@Anonymous 

You can use replace value feature in Query Editor, which is the most straightforward way.

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BA_Pete]

Hi @Anonymous

Try something like:

IF(
ISBLANK([Measure]),
"N/A",
[Measure]
)

[Anonymous]

Hi, 

I tried manipulating my measure but that is showing blank.

My measure is : 

CALCULATE (

COUNTROWS ( MVIEW_PRICING_CHALLENGES ),

FILTER ( MVIEW_PRICING_CHALLENGES,

MVIEW_PRICING_CHALLENGES[CREATEDTIMESTAMP].[Date]

>= ( SELECTEDVALUE ( 'DATE TABLE'[Date] ) - W_NO_DAYS )

&& MVIEW_PRICING_CHALLENGES[CREATEDTIMESTAMP].[Date]

< ( SELECTEDVALUE ( 'DATE TABLE'[Date] ) )

)

)

Can you please tell me how to manipulate this measure ?
or, do we have create one more measure for this apart from my original one ?
Thanks !

[BA_Pete · Accepted solution]

Hi @Anonymous 

I think this should cover your requirement:

yourMeasure =
VAR calc =
//Put all your original measure code into a variable here
CALCULATE (
COUNTROWS ( MVIEW_PRICING_CHALLENGES ),
FILTER ( MVIEW_PRICING_CHALLENGES,
MVIEW_PRICING_CHALLENGES[CREATEDTIMESTAMP].[Date]
>= ( SELECTEDVALUE ( 'DATE TABLE'[Date] ) - W_NO_DAYS )
&& MVIEW_PRICING_CHALLENGES[CREATEDTIMESTAMP].[Date]
< ( SELECTEDVALUE ( 'DATE TABLE'[Date] ) )
)
)
RETURN
//Reference variable within IF statement
IF(
ISBLANK(calc),
"N/A",
calc
)

You could also use the same variable method, but change the code after RETURN to the following to use @Anonymous 's tidier method:

COALESCE(calc, "N/A")

[Anonymous]

Thanks !

I removed that error and it is working properly now.

[Anonymous]

No, still this is no working 
error: the syntax of VAR is incorrect.