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
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure if I understood your question correctly, however, I tried to create a sample pbix file like the below.

One way to do is, insert a Sales total measure into the Filters pane and select the condtion = "is not blank".

 

Please check the below picture and the attached pbix file.

 

  • 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.