Forum Discussion
Help with aggregation in matrix for different total value
Hi, I have table with below data, which I am trying to aggregate into a matrix Store Product Day Interim Final Store1 Prod1 Day1 10 20 Store1 Prod1 ...
// T is your table.
[Unified Quantity] =
SUMX(
VALUES( T[Product] ),
CALCULATE(
MAX(
SUM( T[Interim] ),
SUM( T[Final] )
)
)
)
If you slice and dice your data properly, the result should be what you want.
Best
D