Forum Discussion

PBINoob's avatar
PBINoob
Icon for Helper I rankHelper 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'...
Need Help
PBINoob's avatar
PBINoob
Icon for Helper I rankHelper 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's avatar
PBINoob
Icon for Helper I rankHelper 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's avatar
    MFelix
    Icon for Super User rankSuper 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

    • PBINoob's avatar
      PBINoob
      Icon for Helper I rankHelper I
      8 years ago

      Hi-

      Thank you for the reply and helping me out. I REALLY appreciate it! 

      https://www.dropbox.com/s/139ncwlxw01jm54/temp%20for%20OrderFees%20to%20SKU.pbix?dl=0

       

      Basically, I'm trying to filter the Gross Sales by the ASINList[Short Name] field (bottom left bar chart in the visuals). It's giving me gross sales for each day, but that's with every item (Short Name) summed up... it's not filtering per Short Name- like we said, bc there's no relationship between ASINList table and the OrderFees table.

       

      Please let me know what you think. 

      • PBINoob's avatar
        PBINoob
        Icon for Helper I rankHelper I
        8 years ago

        Any chance you've been able to take a look at this? I'm really stuck and could use the help.
        Thank you!