Percente difference between two filtered values

[Anonymous]

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 

[Anonymous]

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.

[lukiz84 · Accepted 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])
 

[Anonymous]

That did the job! Thanks a lot!

[lukiz84]

Hi,

could you share some sample rows of the table where the data are stored?

BR

[amitchandak]

@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.