Advanced Relationships

[Anonymous]

Hi - I've been struggling with complex relationships for a while and read about the solution here: Link to Microsoft Docs

In the attached PBI file I have an example Dropbox Link

In this example, I have 5 tables

1. Product

2. Customer

3. Sales

4. PriceList

5. ListingList (list of prioritization per SKU per customer)

The tables are related this way:

Image

Now I want to have a list telling me what listing a product has with what customer, just giving me the combinations that are made on the tables: 

Instead, I get a list of all combinations og customer/produkt/listing avalible like this:

How it looks

Unfortunately, I get a list with one line with available listing code - also the ones that are not related to the product/customer... This is because of I'm not able to make a relation between the Customer and the PriceList table without having to sacrifice any other relation... But is there a workaround for this?

I hope you can help

All the best

Kent

[v-xjiin-msft]

Hi @Anonymous,

Thanks for sharing us your pbix file. It helps us a lot to understand your requirement. Could you please also share us your desired result if possible? It will give us the right direction.

Thanks,
Xi Jin.

[Anonymous]

Hi Xi Jin,

I've updated my question. Hope that it's more clear now.

All the best

Kent