Forum Discussion
Percente difference between two filtered values
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 g...
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.