Forum Discussion
Relations & models
Hello Everyone Wanted to ask you, i have a relation between sales & store (1 to many) & product to sales (1 to many) my question, how to make it to display only products available in certain sto...
Hi chahineatallah ,
I checked the PBIX file you shared and found that you selected the "store id" in the "Store Lookup" table, which only contains the number 5.
In “Food Inventory”, the “store id” contains 3.
So you can change the table and then you will get what you want: display only products of store 3.
This is the PBIX file, you can directly to view it for understanding.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly