Don't show table rows unless a row in another table is selected

[kman42]

I have two tables. When I select a row in the first, it filters the second, but if no rows are selected in the first, it shows everything. This is the expected behavior, but not what I want, so I created a measure Filter Check = INT(ISFILTERED('responsible party original data'[ID])). I put this in a card visual and it evaluates correctly: 1 when I have a row selected in the first table and 0 when I don't. I put this measure in the filter panel of the second table, but it doesn't do anything. If I put the measure in the filter panel of a line chart, it works as expected. If I add the measure to the second table, every row evaluates to 1. Any suggestions on how to get this working properly?

Thanks!

[kman42 · Accepted solution]

Solved. I had a relationship in the second table that was screwing it up.

[AnkitaaMishra]

Hi @kman42 , you can mark your message as the solution to close this thread! 🙂
Thanks,

Ankita

[kman42 · Accepted solution]

Solved. I had a relationship in the second table that was screwing it up.

[Anonymous · Accepted solution]

Hi @kman42 

It seems that you have gotten a solution. Could you please mark the helpful post as Answered to close this topic? Thank you very much for your kind cooperation!

Best Regards

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