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.
I have a requirement to assign Corporate Expenses to the several Operating Departments according with the percentage of the Cost of Sales.
1. The percentage of Operating Cost of Sales per Department (% Operating Cost of Sales)
2. The Total Corporate Expenses (Corporate Amount)
3. The expected result is to multiply The Corporate Cost of Sales by the % of Expenses of each Operating Department.
The issue is that I'm not able to assing the Corporate cost on the Operating side.
First row = 22,207,639.31 * 0.26%
....
Last row = 22,207,639.31 * 3.13%
Solved! Go to Solution.
Hi, @gerardotrejogcg ;
Try it.
Measure = MAXX(ALL('Table'),[Corporate Expense])*[% Operating Cost of Sales]
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @gerardotrejogcg ;
Try it.
Measure = MAXX(ALL('Table'),[Corporate Expense])*[% Operating Cost of Sales]
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
This kind of dax should do what you want:
[Allocated costs] = MAX(Table[% operating cost of sales])*CALCULATE(AVERAGE(Table[Corporate expenses]),ALL(Table), Table[Corporate expenses]<>BLANK())
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
I tried to adequate the provided dax with no luck.
This is the expected result I want to reach. Corporate Expense in gray means that currently I'm not able to assign that measure for "Operaciones" (Operating Department) since the result is calculated for "Corporativo" (Corporate Department) only.
The result is limited to apply the Corporate Expense multiplied by % Operating Cost of Sales.
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 |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |