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 everyone,
I am searching a solution for a rather simple task I am struggeling with.
I have to do a financial dashboard, in which the Cash Conversion has to be shown as a percentage. To get the necessary value I have to divide the Operative Cashflow (a) by the EBITDA (b).
To gain the value a in PowerBI I need to filter the "Value" field by an "Account struture". The same has to be done to reach the value for b.
As for Quickmeasure there is just the possibility to filter one variable.
Thanks in advance
Nick
Solved! Go to Solution.
It still would be easier to just show the diagram of how those tables are connected, what is ReportElementID?
Assuming that ReportElementID connects the Account Level Table and the Values table which 1:n (meaning Account Level Table filters Values) you use those 3 measures.
Operative Cash Flow =
CALCULATE(
SUM(Values[Value]),
AccountLevels[AccountLevel] = "Operative Cash flow"
)
EBITDA =
CALCULATE(
SUM(Values[Value]),
AccountLevels[AccountLevel] = "EBITDA"
)
OpCashFlow % = DIVIDE([Operative Cash Flow], [EBITDA])
In the Account Level table are all different accounts and in the values table are alle corresponding values. These two tables match by the "ReportElementID".
So the get the amount of EBITDA I simply use "Values" as the field and filter by "AccountLevel" to the account "EBITDA". The get the Operative Cash flow I can do the same.
What I don't get is how I can simply divide those two values and display the % within the dashboard.
It still would be easier to just show the diagram of how those tables are connected, what is ReportElementID?
Assuming that ReportElementID connects the Account Level Table and the Values table which 1:n (meaning Account Level Table filters Values) you use those 3 measures.
Operative Cash Flow =
CALCULATE(
SUM(Values[Value]),
AccountLevels[AccountLevel] = "Operative Cash flow"
)
EBITDA =
CALCULATE(
SUM(Values[Value]),
AccountLevels[AccountLevel] = "EBITDA"
)
OpCashFlow % = DIVIDE([Operative Cash Flow], [EBITDA])
That did the job! Thanks a lot!
Hi,
could you share some sample rows of the table where the data are stored?
BR
@Anonymous , Are you looking for something like this
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |