Forum Discussion
ctedesco3307
Resolver II
4 years agoCalculated Columns totaling in Matrix
Hey All – I need help creating a measure that will give me the right totals I have a table that has Projects and then Project roles underneath It has the total Working days in the contract (Max ...
- 4 years ago
I was able to solve my issue -thank you all.
tamerj1
Community Champion
4 years agoHi ctedesco3307
I couldn't see where it works. However, in general you can do
SUMX (
SUMMARIZE ( 'Table', [Column1], [Column2] ),
CALCULATE ( the max aggregation )
)
where Column1 and Column2 are the columns placed in the rows of the matrix