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
Thanks for your thoughts.
I would like to have the sum of the methodology, e.g. Kido Qty 7 from Method 1 and Qty 18 from Method 2 = 25. The CUS# doesn't matter, but the report is build based on the customer info.
- bhanu_gautam
Super User
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
That is what I was looking for.. couldn't get my head around it 🙂 Thanks!