Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
Please can someone help me with my calculation.
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
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 |
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.
AssetType | Recycled | Reused |
Laptops | 2,876 | 33,352 |
Monitors | 3,600 | 76,568 |
Printers | 0 | 88 |
Server | 300 | 312 |
Total | 6,776 | 110,320 |
Solved! Go to Solution.
Hi @Anonymous
Try this 2 formulas:
1.
the pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
It works, thank you for your help! 🙂
Hi @Anonymous
Try this 2 formulas:
1.
the pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |