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

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's avatar
BA_Pete
Icon for Super User rankSuper User
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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks !

    I removed that error and it is working properly now.