Forum Discussion
Filtering two tables with identical data by SELECTEDVALUE
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
ok, for all meassures I add formula
asdf Removefilters = calculate([asdf],Removefilters('table'[column]))
6 Replies
this does not work. then the measure does not respond to the click
Can you share the pbix?
sorry but I cant. Thin is model with Dim and Fact and meassures
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 clickedok, for all meassures I add formula
asdf Removefilters = calculate([asdf],Removefilters('table'[column]))
