Counting the number of items for a certain date

[Anonymous]

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?

[mlavey24 · Accepted solution]

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.

[Anonymous]

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