Forum Discussion

chahineatallah's avatar
chahineatallah
Helper III
4 years ago

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...
DAX
Help
Models
relationships
chahineatallah's avatar
chahineatallah
Helper III
4 years ago

hi again

in my model i have customer table which is related to sales table

also i have product table related to sales table

 

now when i create a matrix with customer ID & product, i get the products for each customers & sales for each customer by product,  how is that? as customer & products are not related , to my knowledge it should not work

Thanks

link to my file

https://catallah-my.sharepoint.com/:u:/g/personal/chahineatallah_catallah_onmicrosoft_com/ESJ6nEkGn8ZAg0KFk76RFSMBXYaGByXeEAwwTdm9dICrtA?e=UC7gKJ