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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ffiorellino
Frequent Visitor

Find all suppliers, including also those for similar items

Hi, I can't figure out this (used also chatGPT and Gemini): 

in power bi i have a table 'Table1' with two columns: Suppliers and Items. i want to select an item and have as a result the list of those Suppliers associated with that selected item only. in addition to that if one of the Suppliers in this list is associated to other items, I want to include in the same result list also all those suppliers of each other item. E.g. starting table (associations Suppliers/items):

SuppliersItems
Supplier1item1
Supplier5item1
Supplier7item3
Supplier10item2
Supplier5item2
Supplier1item3
Supplier8item4

if I select item1, I would like to have as answer this set of suppliers: Supplier1 and Supplier5 ... but not only: I would like also Supplier7 and Supplier10 (because Supplier5 can supply Item2, as Supplier10 can do, may be Supplier10 can supply item1 as Supplier5 can). Supplier8 has no relation

This is a kind of recursive iteration (but for me it is enough to have 2 levels) 

thanks for your time

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

2 REPLIES 2
ffiorellino
Frequent Visitor

it works, clean and neat. thank you!

I'm testing it, I'll let you know

Ahmedx
Super User
Super User

pls try this

Screenshot_1.png

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors