Relation Problem with Dimension and Fact Table.

[SebSchoon1]

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!!

[Anonymous]

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 · Accepted solution]

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