Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
57 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
116 | |
42 | |
40 | |
28 | |
22 |