Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Companyuser101
Helper II
Helper II

Divide two values from different tables that depend on slicers

Hello, 

 

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

Companyuser101_0-1663827495891.png

 

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

 

Companyuser101_1-1663827546312.png

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:

Companyuser101_2-1663827628035.png

 

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

 

My measure to calculate the profitability values is: 

Companyuser101_3-1663827675477.png

 

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!

 

 

 

2 REPLIES 2
v-rzhou-msft
Community Support
Community Support

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.

RicoZhou_0-1663926749616.png

 

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.

 

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.

Companyuser101_0-1664366404305.pngCompanyuser101_1-1664366425954.png

 

but here is no value. 

 

The value is then calculated with this measure:

Companyuser101_2-1664366499603.png

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. 

Companyuser101_3-1664366538029.png

 

 

Thanks!

 

 

 

 

 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.