How do I show 0 instead of (BLANK) on data card

[karlamaddox1]

Count of TicketStatus for Working =

CALCULATE(

    COUNTA('ABF Unique Address Request form V1 (2)'[TicketStatus]),

    'ABF Unique Address Request form V1 (2)'[TicketStatus]

        IN { "Working" }

)

I am trying to get it to give me a "0" instead of blank on data card visualization. please help 

[Anonymous · Accepted solution]

Hi @karlamaddox1 

Please try this formula .

Count of TicketStatus for Working =
var _count=CALCULATE(COUNTA('ABF Unique Address Request form V1 (2)'[TicketStatus]), 'ABF Unique Address Request form V1 (2)'[TicketStatus] IN { "Working" })
return IF(_count=0,0,_count)

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tackytechtom]

Hi @karlamaddox1 ,

Just add a zero to your code like this :

Count of TicketStatus for Working =
CALCULATE(
    COUNTA('ABF Unique Address Request form V1 (2)'[TicketStatus]),
    'ABF Unique Address Request form V1 (2)'[TicketStatus]
        IN { "Working" }
) + 0

Let me know, if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[karlamaddox1]

It gave me an error.