Matrix row total not matching values

[Freekh]

Hi,

I can't seem to calculate the correct weektotal. The values calculated per day are correct and need to be summed per week.

This is the formule is use:

Below the values which are returned:

The total I am looking for is 17+24+13+5+2 = 61

Is there a way to calculate this total?

[AlexisOlson · Accepted solution]

Try moving your first three variables inside so they are calculated for each date separately.

# Rest Pallets =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( fct_Scanning, dimDate[Date], fct_Scanning[DC] ),
        "RestPallets",
            CALCULATE (
                VAR Pallets = [...]
                VAR FTL = [...]
                VAR WholeFTL = [...]
                RETURN
                    IF ( [...] )
            )
    ),
    [RestPallets]
)

[Freekh]

Hi @AlexisOlson

Thanks a lot

It works!