Forum Discussion

Icon for Helper I rank

Helper I

8 years ago

Complicated Relationship Thru Multiple Tables?

Relationship Diagram- https://imgur.com/3fmWWLU I have a Date Filter/Slicer using Calendar[Date]. --> This works perfectly. I have a Name Filter/Slicer using ASINList[Short Name]. --> This doesn'...

Icon for Super User rank

Super User

8 years ago

Hi PBINoob,

Create a dimension table with unique values with the column that links the Orderitems and Order tables then make the relatioship between those two table through the new one and we will be abble to make the link.

You can use the query editor or dax to create this new table.

Regards
MFelix

PBINoob
Helper I
8 years ago
Thank you for the reply!
Question: The Dim Table links the OrderItems and Orders tables? Or the OrderItems and the OrderFees tables? The OrderFees table is the one that I'm using to calculate the Gross Profits...

Also- the common column/fields in all of those is the Order ID. So use that one?

THANK YOU!
- PBINoob
  Helper I
  8 years ago
  OK- I tried this-
  https://imgur.com/LIZ1bnU
  
  Created a new table with unique values using Order ID.
  
  I then tried to create a relationship between the OrderFees and ASINList- got the same error as before.
  
  I must be missing something- any ideas?
  - MFelix
    Super User
    8 years ago
    Hi PBINoob,
    
    Looking at the image you send out and the information the use of the additional table will not remove the error since two fo your connections are inactive so you would need to use the USERRELATIONSHIP to calculate the measures you need.
    
    Can you share a sample of the PBIX file with the first verison of your relaitonship model and an expect result?
    
    Believe that the error can be context related in terms of the visuals.
    
    Regards,
    MFelix