Forum Discussion
Summarize values from multiple columns over multiple categories
AL01 Create a new calculated column for each methodology that sums the quantities from all methodologies for each row:
DAX
Kido Total =
IF('Table'[Methodology 1] = "Kido", 'Table'[Quantity 1], 0) +
IF('Table'[Methodology 2] = "Kido", 'Table'[Quantity 2], 0) +
IF('Table'[Methodology 3] = "Kido", 'Table'[Quantity 3], 0)Create a measure that sums the Kido Total column across all rows:
Total Kido Quantity = SUM('Table'[Kido Total])
Do similarly for other categories
Super UserAL01 Create a new calculated column for each methodology that sums the quantities from all methodologies for each row:
DAX
Kido Total =
IF('Table'[Methodology 1] = "Kido", 'Table'[Quantity 1], 0) +
IF('Table'[Methodology 2] = "Kido", 'Table'[Quantity 2], 0) +
IF('Table'[Methodology 3] = "Kido", 'Table'[Quantity 3], 0)
Create a measure that sums the Kido Total column across all rows:
Total Kido Quantity = SUM('Table'[Kido Total])
Do similarly for other categories
That is what I was looking for.. couldn't get my head around it 🙂 Thanks!