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")

     

     

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
6 years ago
Hi Anonymous

Try something like:

IF(
ISBLANK([Measure]),
"N/A",
[Measure]
)
  • 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.