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 yes this what i want, but why in my model i have blank in store

 

so as summary , i have a model with store lookup,  product lookup, and sales 

i have also created a store parameter (just for training purposes), when i choose my parameter as store 3, i want it to show me only products in that store & its sales, this is link to my file, dont know why i couldnt attach

maven roasters pbcommunity.pbix

 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Sorry that it is quite difficult for me to understand your data model.

 

Store Lookup table: only has store_id = 5

Sales by Store table: it has store_id = 3,5,8

 

I think, you cannot show store 3 and 8 by using store lookup table. It is correct that it only shows sotre 5, and rest of stores are shwon as blank, because only store 5 information exists.