Forum Discussion

jayasurya_prud's avatar
jayasurya_prud
Icon for Advocate IV rankAdvocate IV
3 years ago
Solved

Difference of Measure - Alternate Solution

Hi, I am working on a dashboard, where I am using cards visuals. Like below       In the card, C = A-B.  Now, I am facing the scenerio in which based on the filters, sometimes the value ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi jayasurya_prud 

    >>But since I am using if condition already in B to replace blabk() with 0, I am not sure hoe to get this. 

    please try this, 

    measure1= if(isblank([measure in card B]),0,[measure in card B])

    and put measure1 into Card B

    measure2= if(isblank([measure in card B]), "NA", [measure in card B])

    and put measure2 into Card C

     

     

     

    Best Regards,

    Community Support Team _Tang

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

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
3 years ago

Hi jayasurya_prud 

>>But since I am using if condition already in B to replace blabk() with 0, I am not sure hoe to get this. 

please try this, 

measure1= if(isblank([measure in card B]),0,[measure in card B])

and put measure1 into Card B

measure2= if(isblank([measure in card B]), "NA", [measure in card B])

and put measure2 into Card C

 

 

 

Best Regards,

Community Support Team _Tang

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