Total per group

[leandroduarte]

Dear Colleagues, I'm trying to make a total per group using this table structure, please let me know the best way to handle it

basically I want to display for each row the total of the group and year, not individual sum per type

Year	Group	Type	Qty		Results Expected
2024	A	Z	5000	Group by A	8200
2024	A	Y	3000	Group by A	8200
2024	A	I	200	Group by A	8200
2024	B	I	200	Group by B	200
2023	A	Z	5000	Group by A	8000
2023	A	Y	3000	Group by A	3000

[PhilipTreacy · Accepted solution]

Hi @leandroduarte 

Download example PBIX file

Use this measure

Measure = CALCULATE(SUM('DataTable'[Qty]), FILTER(ALL('DataTable'), 'DataTable'[Group] = SELECTEDVALUE('DataTable'[Group]) && 'DataTable'[Year] = SELECTEDVALUE('DataTable'[Year])))

Regards

Phil