DAX Group by Calculation

Question

Hello,&nbsp;Please can someone help me with my calculation.&nbsp;I have a dataset which looks like the below, I cannot change the structure of the data. I need to create a calculation which will multiply the 'UnitOfMeasure' (Recycled and Reused) against the associated Unit Weight for that 'AssetType'. e.g. Laptops Recycled (1438) * Laptops Unit Weight (2) = 2876&nbsp;AssetTypevolumeUnitOfMeasureLaptops1438RecycledLaptops16676ReusedLaptops2Unit WeightMonitors450RecycledMonitors9571ReusedMonitors8Unit WeightPrinters0RecycledPrinters11ReusedPrinters20Unit WeightServer25RecycledServer26ReusedServer12Unit Weight&nbsp;I need to calculate the total for Recycled and Reused, in the example provided I should be returned with the total below of 6,776 Recycled and 110,320 Reused.&nbsp;&nbsp;AssetTypeRecycledReusedLaptops&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,876&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33,352Monitors&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 76,568Printers0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 88Server&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 312Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,776&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110,320

ritaf1983 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;Try this 2 formulas:
1.

recycled =
sumx(
&nbsp; &nbsp; SUMMARIZE('Table','Table'[AssetType],"total rec",CALCULATE(sum('Table'[volume]),'Table'[UnitOfMeasure]="Recycled")*CALCULATE(sum('Table'[volume]),'Table'[UnitOfMeasure]="Unit Weight")),[total rec])
2.

reused =
sumx(
&nbsp; &nbsp; SUMMARIZE('Table','Table'[AssetType],"total reu",CALCULATE(sum('Table'[volume]),'Table'[UnitOfMeasure]="Reused")*CALCULATE(sum('Table'[volume]),'Table'[UnitOfMeasure]="Unit Weight")),[total reu])

the pbix is attachedIf this post&nbsp;helps, then please consider&nbsp;Accepting it as the solution&nbsp;to help the other members find it more quickly

Forum Discussion

DAX Group by Calculation

2 Replies

Related content

Calculation Groups help

DAX for calculating retroactive values

DAX Calculated Measure

DAX Calculation

Dax - Calculation group and SVG output

AssetType	volume	UnitOfMeasure
Laptops	1438	Recycled
Laptops	16676	Reused
Laptops	2	Unit Weight
Monitors	450	Recycled
Monitors	9571	Reused
Monitors	8	Unit Weight
Printers	0	Recycled
Printers	11	Reused
Printers	20	Unit Weight
Server	25	Recycled
Server	26	Reused
Server	12	Unit Weight

AssetType	Recycled	Reused
Laptops	2,876	33,352
Monitors	3,600	76,568
Printers	0	88
Server	300	312
Total	6,776	110,320