powerbidaxdata-analysispowerbi-desktopcalculated-columns

How can I summarize sales data by category in a new column?

I would like to create a new column where I can sum units by quarter.

My table like this Another column I would summ unit by product and quarter Edit: Last two col with the expected result

Unit Quarter Product Unit by Quarter Un by Q&Product
4 Q1 Apple 9 4
5 Q1 Orange 9 5
6 Q2 Pearl 12 6
6 Q2 Apple 12 6
3 Q3 Apple 5 3
2 Q3 Apple 5 2
6 Q4 Apple 11 8
3 Q4 Pearl 11 3
2 Q4 Apple 11 8
Solution

  • enter image description here

    Unit by Quarter = CALCULATE(SUM('Table'[Unit]), ALLEXCEPT('Table','Table'[Quarter]))

Un by Q&Product = CALCULATE(SUM('Table'[Unit]), ALLEXCEPT('Table','Table'[Quarter],'Table'[Product]))