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
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!