Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
Tips and Tricks
  • lukiz84's avatar
    lukiz84
    3 years ago

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

     

amitchandak's avatar
amitchandak
Super User
3 years ago

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.