Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Need help in solving below query in Powerbi/Power Pivot.
In Powerpivot I created a Pivottable similar to below, where I created a measure COGP which is sum of RM, PM & Production cost. Now what I need to do is calculate % of COGP for each category and allocate Supply Chain OH accordingly. I have given the Supply Chain OH value at total level. One option I found is to calculate total of each this column (RM, PM, Prod) using All function with calculate and then calculate the contribution. Which is not a good option for me as my model contains more than 10 of this columns.
Is it possible to calculate the % contribution of a measure itself which I can use to multiply a certain value?
Category | Sales | COGP | RM Cost | PM Cost | Production Cost | Supply Chain OH |
A | 1000 | 385 | 222 | 123 | 40 | |
B | 2000 | 786 | 123 | 623 | 40 | |
C | 2000 | 1137 | 463 | 634 | 40 | |
D | 2000 | 706 | 444 | 222 | 40 | |
Total | 500 |
Solved! Go to Solution.
Hi @rajibmahmud
Try this Measure
%age of COGP= [COGP] / CALCULATE ( [COGP], ALL ( Table1 ) )
Hi @rajibmahmud
Try this Measure
%age of COGP= [COGP] / CALCULATE ( [COGP], ALL ( Table1 ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |