Divide two values from different tables that depend on slicers

[Companyuser101]

Hello, 

I have two different slicers where I can select different model types. 

Both slicers look the same, but are based on different tables: 

One is based on the yellow one, the other is Products L3(2) last category. 

Now I have two tables which show the two selected values:

It shows me the profitability per model, which I have selected on the slicers.

My measure to calculate the profitability values is: 

Now I want to have another table which divide the two values in the tables above, so I can see the percentage difference between those tables, based on the selected values from the slicers. 

How can I do this? 

Thanks in advance!

[Anonymous]

Hi @Companyuser101 ,

As far as I know, Power BI doesn't support us to create a dynamic table which can be filtered by slicer. Here I suggest create measures and then create a table visual by these measures.

Select from table1 = SELECTEDVALUE('Products L3'[Category])

Select from table2 = SELECTEDVALUE('Products L3 (2)'[Category])

Diff between table1 and table2 = SELECTEDVALUE('Products L3 (2)'[Value])  - SELECTEDVALUE('Products L3'[Value])

Percentage = DIVIDE([Diff between table1 and table2],SELECTEDVALUE('Products L3'[Value]))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Companyuser101]

Hello,

thanks for the reply.

Your proposal does not work completly for me.

I have two slices with my products. And then I have a measure which calculates the profitability per product.

This are my products in my slicer fron my "product" data.

but here is no value. 

The value is then calculated with this measure:

This data is not based on the product data. Its based on the "profitabilität_aktuell" data.

But I have a relationship between those two. 

Thanks!