Calculating outstanding tickets

Hi brokencornets ,

Thank you for reaching out to the Microsoft fabric community forum.

The issue you're facing where April doesn't appear despite having data is likely due to the visual not rendering months with no matching rows after filters are applied.

Here’s what we recommend:

1. Extend your Date table to include future dates, e.g., up to EOMONTH(TODAY(), 6), and ensure it's marked as a Date Table.
2. In your visual, enable "Show items with no data" on the date axis to display all months.
3. Use the revised measure below to preserve date context and return accurate outstanding counts:

Outstanding = 
VAR ReferenceDate = MAX('Date'[Date])
RETURN
CALCULATE (
    COUNTROWS('Tickets'),
    FILTER (
        ALL('Tickets'),
        'Tickets'[Date Reported] <= ReferenceDate &&
        (
            ISBLANK('Tickets'[Date Completed]) ||
            'Tickets'[Date Completed] > ReferenceDate
        )
    )
)

This will ensure proper month-by-month reporting even if no tickets are active in certain periods.

I hope this will resolve your issue, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.