Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
H3nning
Resolver I
Resolver I

Filter Table based on selector in unrelated table

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
111
201
300

 

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!

1 ACCEPTED SOLUTION
H3nning
Resolver I
Resolver I

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])
)

View solution in original post

2 REPLIES 2
H3nning
Resolver I
Resolver I

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])
)

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.