Forum Discussion

Sean's avatar
Sean
Community 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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I have the same problem. Could someone please help me how to solve it with the +0 resolution ?

 

I have a card counting total number of tickets in first column. when i select specific names in slicer it shows (blank) instead of 0. I understand i need to create measure, but what do i do when the measure is created ? how can i use it ?

 

if the corrent formula is measure = expression + 0

 

what should be under expression if the card is counting total number if tickets in column A ? sum(table(columnA)) ? and when the measure is created how can i apply it to the card ?

 

thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous

     

    That's correct, just add +0 after the expression. 

     

    If your table(column A) contains counts of tickets then your formula expression should be OK. 

     

    If each row is for a different ticket you could also use countrows(table)+0. 

     

    Not sure if that helps. 

     

    Matt