Unable to Filter Across Three Tables

[1001]

Hi All,

I have a series of tables, each connected through a common Unique ID Number.

However, from the diagram below, I am trying to use a filter (Shelf Life) from my ZPLAN table to filter Products containing ShelfLife in the ZSLED table, but the relationhsip isn't working. Just wondering if anyone had any pointers?  Many thanks.

[1001 · Accepted solution]

Thanks for your help all,

I ended up cheating, deciding to save the Existing Excel Pivot Table including related column formulass, as 'values only' to a new sheet as that day's date. Then I imported those daily files into PBI and consolidated them into one single table. Everyhting's now outputting as I need. 

Cheers.     

[FreemanZ]

hi @1001 

The relatiinship between ZPLAN and ZSLED is many-many. You can try to set the cross filter direction between Master and ZSLED as Both. See if it works.

If that doesn't work, try check this

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-many-to-many-relationships

[1001]

Sorry Pratyashasanal,

not working. I think the issue is I may have to create a unique Shelf Life number table that feeds into ZPLAN and use that as my filter. Will try that.

Thanks.

[pratyashasamal]

Hi @1001 ,
Please try to make the relationship between Masterdata and ZSLED Prior Week Table to bidirectional .
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C