Filtering two tables with identical data by SELECTEDVALUE

[Marcin86]

Hi ,
I have two identical tables in the report table A and table B. Table A is to select an article by clicking on a row and table B is to display articles belonging to the same group.

However, when I click a row in table A, table B also displays only one row.

I had an idea to use the measure :
var selected=SELECTEDVALUE(Impl[IL GroupName])
var group=min(Impl[IL GroupName])
return
IF(
selected=group,1,0
)
but it doesn't work. PBI filer to one row

[Marcin86 · Accepted solution]

ok, for all meassures I add formula
asdf Removefilters = calculate([asdf],Removefilters('table'[column]))

[Marcin86]

should work like this:
- the top table and the bottom table are the same
- clicking on a row in the upper table filters the lower table on the basis of the WO num. column, i.e. shows all rows with the same WO num. as the clicked

[Anonymous]

You need to turn off Edit Interactions between the 2 visuals - Click on the first table and go to the Format menu - click Edit Iteractions and turn off the filtering between the tables

[Marcin86]

this does not work. then the measure does not respond to the click

[Tutu_in_YYC]

Can you share the pbix?

[Marcin86]

sorry but I cant. Thin is model with Dim and Fact and meassures