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.
Hello masters,
i need your support to calculate the percentage of other cost to sales cost. In below, I have cost data and sales data in one table.
Could someone tell me what the problem is and how to show the percentage for each row?
Thanks!
Solved! Go to Solution.
Hello @Tonyy
Try this
Cost to Sales - % =
Divide(
[Total HFM Cost],
CALCULATE(
[Total HFM Cost], 'HFM data'[Cost type]="Production sales",ALL('HFM data'Cost type (groups))
), 0
)
Hope it solves and this is what were looking for.
Hello @Tonyy
Try this
Cost to Sales - % =
Divide(
[Total HFM Cost],
CALCULATE(
[Total HFM Cost], 'HFM data'[Cost type]="Production sales",ALL('HFM data'Cost type (groups))
), 0
)
Hope it solves and this is what were looking for.
Thanks so much!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |