Subtotal includes blank values matrix

[Sebastián]

Hello!

I made a measurement to calculate the comparison of sales from last year but day by day, that is, Monday to Monday, it worked for me but the total by month does not appear in the dynamic table, only by date.

This is the formula I am using

Vta AA_2 =
CALCULATE (
    [Vta 2022];
    FILTER ( ALLSELECTED ( Calendario ); Calendario[Año] = MAX ( Calendario[Año] ) - 1 );
    FILTER (
        ALLSELECTED ( Calendario );
        Calendario[Semana] = MAX ( Calendario[Semana] )
    );
   VALUES ( Calendario[Día] ))

[amitchandak]

@Sebastián , with help from date/calendar table try a measure like

week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))