Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Advanced Relationships

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

Need Help
Tutorial Requests

2 Replies

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Xi Jin,

       

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

       

      All the best

       

      Kent