Forum Discussion

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

Blank( ) in Card/Multi-row Card

Is there an easier way to output 0 instead of blank in a card / multi-row card   I've been using => IF ( ISBLANK (expression), 0, expression )   Is there any way to avoid repeating the expression...
Need Help
austinsense's avatar
austinsense
Icon for Impactful Individual rankImpactful Individual
10 years ago

Little simpler, but you still have to repeat the expression IF ( [Measure], [Measure], 0 )

Virtual_Ames's avatar
Virtual_Ames
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Austin,

 

Great reply, thanks. This would mean that for every card on a dashboard where I do not want to see "BLANK" - I need to create a new measure and apply this IF. Is that correct? Or is there some way to have this act as a global setting?

 

Best, and thanks again.

 

Brian