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,
I have a P&L Table, sorted by Month.
I created the following measures to visualize the data: (note there are Slicers)
Numerator =
VAR Cost_of_Material = CALCULATE([Actuals];
FILTER('Financial Category'; 'Financial Category'[Category] = "Cost of Material"))
VAR Personnel = CALCULATE([Actuals];
FILTER('Financial Category'; 'Financial Category'[Category] = "Personnel"))
VAR other_Exp = CALCULATE([Actuals];
FILTER('Financial Category'; 'Financial Category'[Category] = "other op. Exp."))
VAR other_Inc = CALCULATE([Actuals];
FILTER('Financial Category'; 'Financial Category'[Category] = "other op. Inc."))
VAR Depreciation = CALCULATE([Actuals];
FILTER('Financial Category'; 'Financial Category'[Category] = "Depreciation"))
RETURN
(Cost_of_Material + Personnel + other_Exp + Depreciation + other_Inc)
3. Measure "Total Output" gives the total Sales in the selected month.
Total Output =
CALCULATE([Actuals];
FILTER('Financial Category'; 'Financial Category'[Category] = "Sales Revenue"))
4. Measure "% of Sales Revenues" should give the percentage of each Numerator divided by Total Output.
% of Sales Revenue =
[Numerator]/[Total Output]) // or DIVIDE([Numerator];[Total Output];0)
As you can see, the 4. Measure isn't showing my anticipated results. If I enter the static number of Sales Revenues (in the table = 4,836 Mil. €), I receive the correct percentages in the column.
I tried several approaches to get the percentage. It seems that I can't put a measure, which only refers to one value, in the Denominator. I won't be able to add the Total Output manually in the Denominator using IF-clauses, since the table will update regularly.
Is there any way to divide the Nominators by Sales Revenue??
Thanks in advance
Solved! Go to Solution.
Thanks a lot, it works! Finally!
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |