Forum Discussion

BrianNeedsHelp's avatar
BrianNeedsHelp
Resolver I
1 year ago
Solved

Sum Certain Rows but Keep in same Column

I have a table like this:   Product Totals Data1 20 Data2 10 Product1 50 Product2 100 How could I add the Data1 and Data2 rows together and keep it in the same Product colu...
calculation
Measures
Summing
  • techies's avatar
    techies
    1 year ago

    Hi BrianNeedsHelp  an alternative approach is to create calculated column like this

     

    Product Group =
    SWITCH(
        TRUE(),
        'ProductsTable'[Product] IN {"Data1", "Data2"}, "Data",
        'ProductsTable'[Product]
    )