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 all,
If anyone can help me it is much appreciated.
I have a financial report were I divide the differend revenues by the total revenue. This is working.
But now I like to divide the costs also by the total revenue. I first made a formula for the total Revenue.
Now I thought it was simple to get all the percentages by replacing the "Numerator" in:
I have search a lot of time to solve this problem, but I overlook something. And I hoop that one of you can help me with this.
Thank you in advance!
Solved! Go to Solution.
I found the solution myself. Maybe someone else has the same problem and can use this solution.
First measure is for % of subtotals when the revenue is 100%.
Hi @RCL ,
You can try to create a measure.
Kosten%2 =
VAR Omzetverpakken =
CALCULATE (
SUM ( 'GeneralLedgerBalances'[AmountDC] ),
'Volgorde'[Rapportage omschrijving] = "Omzet verpakken",
ALLSELECTED ( 'Rapportage_Grootboek'[oms25_0], 'Rapportage_Grootboek'[reknr] )
)
RETURN
DIVIDE (
SUMX (
SUMMARIZE (
'Rapportage_Grootboek',
'Rapportage_Grootboek'[column1],
'Rapportage_Grootboek'[column2],
"measure", SUM ( 'GeneralLedgerBalances'[AmountDC] )
),
[measure]
),
Omzetverpakken,
0
)
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-tangjie-msft ,
Thanks for your reply!
I have tried your formula. I added one table. See below.
Unfortunately I get the same result.
So all the amounts and subtotals must be divided by EURO 385.177, the subtotal of 'Omzet verpakken'.
I use the following tables:
1)
'GeneralledgerBalances'[AmountDC] and 'GeneralledgerBalances'[Date]
2) 'Rapportage_Grootboek'[oms25_0] and 'Rapportage_Grootboek'[reknrt]. Last one to sort the first one.
3) 'Volgorde'[Rapportage omschrijving]
4) 'Volgorde Subtotals'[Subtotals]
Between those I have a relation between 'Rapporage omschrijving'.
And I use the following columns in my Matrix:
"Omzetvergelijk" = 'Volgorde subtotals'[Subtotals]
I hope it is clear now what I like to have in my report. Not a very strange report I think, but somewhere I am making a mistake? I hope you or someone else can help me further.
If you do not have enough information I will make a simplefied pbix file. Please let me know if that is necessary.
Thank you again!
Best regards,
Robert Links
I found the solution myself. Maybe someone else has the same problem and can use this solution.
First measure is for % of subtotals when the revenue is 100%.
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 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |