Forum Discussion
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 column so it's like this:
| Product | Totals |
| Data | 30 |
| Product1 | 50 |
| Product2 | 100 |
Hi BrianNeedsHelp an alternative approach is to create calculated column like this
Product Group =SWITCH(TRUE(),'ProductsTable'[Product] IN {"Data1", "Data2"}, "Data",'ProductsTable'[Product])
2 Replies
Hi BrianNeedsHelp an alternative approach is to create calculated column like this
Product Group =SWITCH(TRUE(),'ProductsTable'[Product] IN {"Data1", "Data2"}, "Data",'ProductsTable'[Product])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
