Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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 , 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
Fantastic! This worked! Thank you very much!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |