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])
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!