Forum Discussion
Solved
Summarize values from multiple columns over multiple categories
Hi, I am struggeling to perform a calculation which gives me the total sum of quantities across all methologies 1/2/3. So far, I can only compute seperate sums, but not a combined total. ...
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
Deku
Super User
Super UserIf you want the sum per CUS#
Quantities = SUM( tbl[quantity 1] ) + sum( tbl[quantity 2] ) + sum( tbl[quantity 3])