Forum Discussion

AL01's avatar
AL01
New Member
1 year ago
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.     ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    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

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

AL01 You can create a new calculated column that sums the quantities from all methodologies for each row.

DAX
Total Quantity =
'Table'[Quantity 1] + 'Table'[Quantity 2] + 'Table'[Quantity 3]

 

You can create a measure that sums the Total Quantity column across all rows.

Total Sum of Quantities =
SUM('Table'[Total Quantity])

 

You can then use this measure in your Power BI report to display the total sum of quantities across all methodologies.