Forum Discussion
Filtered Results Error
Hi Guys, Wonder if anyone can help with issue I have with filtered results. I have a report that shows Inventory Data with current quanties, with two filtered reports that show Purchase orders a...
Hello lesg ,
I would suggest you create dimension table for items that have all items without duplication and link it to all 3 tables.
then use it to show and filter data.
check the concept of star schema modeling https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Thanks for your quick response, not sure I fully understand your suggestion yet, will go through the linked document and see if I can make sense of this.