Forum Discussion
How show 0 when Month Ticket count is zero
currenty, I am trying to calculate montly ticket count.
If month has no tickets opned up, it should show 0 count for that month.
Hi PaulJ185 ,
Thank you for engaging with the Microsoft Fabric Community. Please try the approach suggested below. In your tickets table, create a new measure.
Ticket Count = COALESCE( COUNTROWS('Table'), 0 )Result:
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
4 Replies
Hi PaulJ185 ,
Thank you for engaging with the Microsoft Fabric Community. Please try the approach suggested below. In your tickets table, create a new measure.
Ticket Count = COALESCE( COUNTROWS('Table'), 0 )Result:
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
Would be great if you could have provided the formula you wrote.
Just add zero to your formula that should give the desired result
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
I am not using any formula, just table matrx. Any suggestion formula?
