How to filter one table if clicks on any row of the another table

[adityakumar619]

I have two tables one is "Sheet1" and other is "exp2".Suppose if i clicks on any row of table(i.e sheet1) it show the relavent data i.e filtered data coreesponding to that row.

Say if i click on below 2 row of table1 i.e "Sheet1",it should display rows correspondin to that in table2 i.e exp2.

And if i unselect that row,it should revert to my original data in table2i.e exp2

Note:here i don't want to use relationship within the datamodel by making connections i.e CPL of one table with CPL of other table.i.e many to many or one to many etc.

But needs to do via DAX using USERELATIONSHIP.Since i need to do this on the fly.

I have tried using below DAX but no luck.

Measure = IF(ISFILTERED('Sheet1'[CPL])=TRUE(),CALCULATETABLE(exp2,USERELATIONSHIP('exp2'[CPL],'Sheet1'[CPL])))

 Desired o/p:

if i unselects,it should revert to orignal data in exp2.

[Anonymous · Accepted solution]

Hi @adityakumar619 ,

Forget about the USERELATIONSHIP(). How about a single measure like below.

Measure = IF(SELECTEDVALUE(exp2[CPL]) in VALUES(sheet1[CPL]),1,0)

And you just need to add it to visual filter as below.

Best Regards,

Jay

[Anonymous · Accepted solution]

Hi @adityakumar619 ,

Forget about the USERELATIONSHIP(). How about a single measure like below.

Measure = IF(SELECTEDVALUE(exp2[CPL]) in VALUES(sheet1[CPL]),1,0)

And you just need to add it to visual filter as below.

Best Regards,

Jay

[adityakumar619]

@Anonymous  how can i apply the  measure if the table2 column[cpl] has different values compared to table1[cpl].below measure is filtering only the common values in that column.

and it should filter the status table aswell.

Measure = IF(SELECTEDVALUE(exp2[CPL]) in VALUES(sheet1[CPL]),1,0)

[adityakumar619]

@Anonymous below is my expected output.if the common column contains different values.

[adityakumar619 · Accepted solution]

@Anonymous Checking on it

[adityakumar619]

Note:i need to do via on the fly click on any rows with out having relationship connections which i tried and succeed,but really i need to know via DAX simply by clicking and making the use of USERELATIONSHIP

[adityakumar619]

Hi Team,Is anyone help on the above. As i need have relationship on the fly.so that it can filter the selected rows in the other table and if unselects i need to get my original data.