Bridge table or many to many relationship odd behaivor

[oscarmqz]

Hi, I have 2 tables, one with all the fact data for orders from customers and then I have a dimension by customer, the wave and team they are part of, a customer can be part of two teams so the relationshp wouldbe a many to many. I tried using the many to many relationship directly in power BI with cross filtering set to BOTH but it didn't work. Then I tried the old way creating a bridge table with unique IDs from both tables and creating Many to 1 - 1 ToMany relationships with the bridge, but the outcome is the same. I cannot pull fields from my tables.... here are a couple screenshots

If I use a report level filter based on Query 1, then Waves data goes blank, and the other way around, if I select something on waves, then data on Query 1 goes blank.

[v-shex-msft]

HI @oscarmqz ,

Can you please share a pbix file for test? It is hard to troubleshoot without any sample data.

Notice: do mask on sensitive data before share.

Regards,

Xiaoxin Sheng