Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using message N/A instead of BLANK

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 somet...
Need Help
  • BA_Pete's avatar
    BA_Pete
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago
Create a new measure based on the one you have:

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

Best
D