Filter Table based on selector in unrelated table

[H3nning]

Hi, I have so following problem and I hope someone can assist.

I have a Table with two values which I use as a selector.

SWITCH

A

B

And I have another table which I want to filter based on the slicer in SWITCH:

ID	_ifA	_ifB
1	1	1
2	0	1
3	0	0

So if A is selected my table visual should only show row 1. If B is selected it should show 1 and 2.

Thanks in advance!

[H3nning · Accepted solution]

Found it myself. I just had to add a measure summing up _ifA and _ifB depending on the Slicer. And then I added the SUm to the filter pane of the visual wit the ID already in it and said SUM >0. 

SWITCH(VALUES('Switch'[SWITCH])

    ,"A", SUM(table[_ifA])

    ,"B", SUM(table[_ifB])

    ,SUM(table[_ifA])

)

[v-jingzhang]

Hi @H3nning

Glad you have solved it by yourself! You can accept your reply as solution to close this thread. A closed thread will help other people find your solution more quickly. 

Best Regards,
Community Support Team _ Jing