The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Solved! Go to Solution.
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.
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.
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
It gave me an error.
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |