How to use a single filter on a single table with multiple relationships

Question

Apologies for the poor description, but I don't know how to word it.

Essentially I have a supply chain mapped in an excel file (uploaded to a single tablein power BI), it looks a little something like this

Tier 1 Tier 2 Tier 3

Supplier A	Supplier 1	Supplier x
Supplier A	Supplier 2	Supplier y
Supplier A	Supplier 3	Supplier z
Supplier B	Supplier 4	Supplier z
Supplier B	Supplier 5	Supplier 2
Supplier B	Supplier 1	Supplier v

Now, I want to create a single filter on 'Supplier Name' which when selected will only show me that suppliers 'supply chain'

EG if supplier 'x' is selected then i would expect the following return

Tier 1 Tier 2 Tier 3

Supplier A	Supplier 1	Supplier x
Supplier A
Supplier A

if supplier '1' is selected i would expect the following return

Tier 1 Tier 2 Tier 3

Supplier A	Supplier 1	Supplier x
Supplier B	Supplier 1	Supplier v

I havbe tried splitting out the tier tables, and creating a master but the joins wont allow this to function as expected.

The issue is a supplier in tier 2 or 3 can appear in each section - suppliers in tier 1 will only appear in tier 1

Any help?

onurbmiguel_ · Answer

Hi&nbsp;&nbsp;&nbsp;Jtbonner1986&nbsp;&nbsp;Please check my solution in the file:&nbsp;Filter with Path&nbsp;i cretated a table with all Suppliers:&nbsp;&nbsp;&nbsp;i created also a column with the path of each supplier:&nbsp;&nbsp;&nbsp;and then i created a measure to filter :&nbsp; &nbsp;in the visual i used the measure to filter :&nbsp;&nbsp;&nbsp;Any question just ask.&nbsp;&nbsp;&nbsp;Best regardsBruno Costa |&nbsp;Power Participant&nbsp;Hope this answer solves your problem!If you need any additional help please @ me in your reply.If my reply provided you with a solution, please consider marking it as a solution or giving it a kudoeYou can also check out BI4ALL's website and our data solutions!&nbsp;

anonymous · Answer

Hi&nbsp;Jtbonner1986&nbsp;
You can refer to the following solution
1.Create a slicer table
Slicer = var a=SUMMARIZE('Table',[Tier1])
var b=SUMMARIZE('Table',[Tier2])
var c=SUMMARIZE('Table',[Tier3])
return SUMMARIZE(UNION(a,b,c),[Tier1])

&nbsp;
2.Create a calculated column in data table
Combine = [Tier1]&amp;","&amp;[Tier2]&amp;","&amp;[Tier3]
3.Then create a measure, and put the measure to the visual filter
Measure = IF(ISFILTERED(Slicer[Tier1]),IF(CONTAINSSTRING(SELECTEDVALUE('Table'[Combine]),SELECTEDVALUE(Slicer[Tier1])),1,0),1)

&nbsp;
Output

&nbsp;

&nbsp;
Best Regards!
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.