TotalYTD returning blank

Hi kinga,

Thanks for your patience and the detailed updates!

I now fully understand the issue, the main challenge is that when the selected Year Week (like 2025-13) has no records for a TR Type (e.g., AOG), the YTD measure returns 0, even though there were values in earlier weeks (like 13 in 2025-12).

I’ve rewritten the DAX to better handle this. It now:

• Finds the last non-blank week for each TR Type up to the selected week.
• Returns the full YTD total up to that last available week, even if the current week has no data.

Please try this revised measure:

YTD Shipments =

VAR SelectedYearWeek = MAX ( 'Table'[YearWeek] )



VAR LastNonBlankWeek =

    CALCULATE (

        MAX ( 'Table'[YearWeek] ),

        FILTER (

            ALL ( 'Table' ),

            'Table'[YearWeek] <= SelectedYearWeek &&

            'Table'[Shipments] > 0 &&

            'Table'[TR_Type] = SELECTEDVALUE ( 'Table'[TR_Type] )

        )

    )



RETURN

    CALCULATE (

        SUM ( 'Table'[Shipments] ),

        FILTER (

            ALL ( 'Table' ),

            'Table'[YearWeek] <= LastNonBlankWeek &&

            'Table'[TR_Type] = SELECTEDVALUE ( 'Table'[TR_Type] )

        )

    ) + 0

This should now return 13 for AOG even when 2025-13 has no entries.

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.

Thank you for using Microsoft Community Forum.