topic Re: How show 0 when Month Ticket count is zero in Developer

How show 0 when Month Ticket count is zero

PaulJ185 — Mon, 21 Apr 2025 02:41:00 GMT

currenty, I am trying to calculate montly ticket count.

If month has no tickets opned up, it should show 0 count for that month.

Re: How show 0 when Month Ticket count is zero

tharunkumarRTK — Mon, 21 Apr 2025 02:51:58 GMT

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!

Re: How show 0 when Month Ticket count is zero

PaulJ185 — Mon, 21 Apr 2025 03:11:08 GMT

I am not using any formula, just table matrx. Any suggestion formula?

Re: How show 0 when Month Ticket count is zero

tharunkumarRTK — Mon, 21 Apr 2025 05:00:06 GMT

Create a dax measure

Distinc Count = Distinctcount(Table[Column]) + 0

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!

Re: How show 0 when Month Ticket count is zero

V-yubandi-msft — Mon, 21 Apr 2025 11:05:26 GMT

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.