Sum Certain Rows but Keep in same Column

[BrianNeedsHelp]

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 column so it's like this:

Product	Totals
Data	30
Product1	50
Product2	100

[techies · Accepted solution]

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

Product Group =

SWITCH(

    TRUE(),

    'ProductsTable'[Product] IN {"Data1", "Data2"}, "Data",

    'ProductsTable'[Product]

)

[FBergamaschi]

Create a calculated column

Category = IF ( Product[Product] IN {"Data1", "Data2}, "Data", Product[Product] )

Then group this column

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI