topic Re: Counting the number of items for a certain date in DAX Commands and Tips

Counting the number of items for a certain date

Anonymous — Wed, 15 May 2019 15:16:45 GMT

I have a ticketing system that gives me a

-Work Order number

-A open date

-a closed date

I'm trying to create a line graph that will show on a week by week basis how many open tickets on a particular date. I'm struggling with the DAX logic that will show on date XXXX that a ticket is open based on the open and closed dates. Can anyone help me out?

Re: Counting the number of items for a certain date

mlavey24 — Wed, 15 May 2019 18:22:52 GMT

This should do the trick.

Measure =

COUNTROWS (
CALCULATETABLE ( 'TicketTable', 'TicketTable'[ClosedDate] <> BLANK () )
)

Obviously replace the table and column names with the actual object names that exist in your PBI model.

Re: Counting the number of items for a certain date

Anonymous — Thu, 16 May 2019 19:23:21 GMT

Thanks! That works! So simple...ugh!