Calculating Open Tickets on a Specific Day of the Month

[Anonymous]

I created a chart using these, it looks at the tickets open between two dates and then aggregates it by month.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

My boss also wants another measure that will show the number of tickets open on the 4th day of each month (so the entire month of January would show as what it was on Jan. 4th -- any ideas of how to do this?

[TeigeGao]

Hi @Anonymous ,

Please refer to the following DAX query:

Measure = CALCULATE(COUNTROWS(Tickets),FILTER(Tickets,Tickets[Opened Date].[Day]=4))

Best Regards,

Teige