Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago
Solved

Relation Problem with Dimension and Fact Table.

Hi Fellows,

 

I have a new question today, 

 

I'm struggling with a relation ship ( I think) Or a measure.

 

I would like to Calculate 

 

The items In Stock By supplier By warehouses By Dispatch Rank (Priority)

 

here's my model

 

I cant obtain the result To show The Stock Value 

 

ONLY in the corresponding Warehouse (Here Warehouse 015)

 

 

May I ask any Help on my Dax Calculate or modeling problem?

 

Many thanks!!

 

Need Help
  • SebSchoon1's avatar
    SebSchoon1
    3 years ago

    Hi, I wanted to get the quantity in stock for each items

     

    I have been able to do it by changing relations to bidirectional for some

     

    Here's the picture of the model

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi SebSchoon1 ,

    I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting.

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_ Binbin Yu

     

    • SebSchoon1's avatar
      SebSchoon1
      Post Patron
      3 years ago

      Hi, I wanted to get the quantity in stock for each items

       

      I have been able to do it by changing relations to bidirectional for some

       

      Here's the picture of the model