Forum Discussion

PaulJ185's avatar
PaulJ185
New Member
1 year ago
Solved

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. 
Need Help
Tips and Tricks
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    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.

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

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.