Total of measure using showing MAX spend

[Metricbits]

Hi,

Please help me solve the issue with measure showing MAX spend over the last 16 weeks from the date selected in the slicer.

I have this measure and it works on line by line basis, but the total is wrong:

Max Spend last 16 weeks =
VAR MinDate =
    DATEADD ( 'OLAP Vel_Date'[End of Week], -112, DAY )
RETURN
    CALCULATE (
        MAX ( 'OLAP CUBE_VelocityCube_WB'[Consumption / Sale Amount] ),
        FILTER ( ALL ( 'OLAP Vel_Date' ), 'OLAP Vel_Date'[End of Week] >= MinDate )
    )

How should I add the total? I have tried different versions of summarizing, but nothing gave me the right result

[amitchandak · Accepted solution]

@Metricbits , You need to change your return like

sumx(summarize(Table, Table[Row1], Table[Row2], "_1",RETURN
CALCULATE (
MAX ( 'OLAP CUBE_VelocityCube_WB'[Consumption / Sale Amount] ),
FILTER ( ALL ( 'OLAP Vel_Date' ), 'OLAP Vel_Date'[End of Week] >= MinDate )
)),[_1])

where row1 and row2 are the columns in the matrix row. Use the correct name

[Metricbits]

Fantastic! This worked! Thank you very much!