Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Material | RM Category | Cost | % of Cost |
SKU1 | Fuel | 1000 | 38% |
Gas | 250 | 9% | |
Transport | 500 | 19% | |
Direct | 700 | 26% | |
Indirect | 200 | 8% | |
Total Cost | 2650 | 100% | |
SKU2 | Fuel | 750 | 25% |
Gas | 850 | 28% | |
Transport | 900 | 30% | |
Direct | 200 | 7% | |
Indirect | 300 | 10% | |
Total Cost | 3000 | 100% |
Hello Guys : Can you pls provide some guidance to do this % of Cost Column (4) which is the total within product and category of that product ?
Solved! Go to Solution.
@Aravind_Kumar , Try a measure like
divide(Sum(Table[Cost]),calculate(Sum(Table[Cost]), allexcept(Table, Table[SKU])))
or
divide(Sum(Table[Cost]),calculate(Sum(Table[Cost]), filter(allselected(Table), Table[SKU] = max(Table[SKU]))))
Hi @Aravind_Kumar ,
You can try what @amitchandak mentioned, it will give you the expected result. And here is the test result:
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Aravind_Kumar , Try a measure like
divide(Sum(Table[Cost]),calculate(Sum(Table[Cost]), allexcept(Table, Table[SKU])))
or
divide(Sum(Table[Cost]),calculate(Sum(Table[Cost]), filter(allselected(Table), Table[SKU] = max(Table[SKU]))))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |