Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Newbie - Measure for my result?

Hi Guys


I still a developing PowerBi user to bear with me if my question is pretty straightforward.


The below picture depict my Data Model

Data Model


Below is the relationship for this model


Data Relationship


What im trying to achieve is to get the qty on hand for my selected supplier by orders as per below.




Any help will be appreciated.


Hi @AColeman


Could you try removing the relationship between Dim_StockCode and Fact_InvWareHouse first, and set cross filter direction to Both for the relationships between Fact_PorMasterDetail and Dim_Warehouse, and the relationship between Dim_Warehouse and Fact_InvWarehouse.


Then you should be able to drag the QtyOnHand column to your Table visual to get your expected result. Smiley Happy



This does not bring throug the qty on hand for the individual product it seems to bri g the summary value for all stock on hand as the figure displaying for each line is the same. Value of 339'881.25

Helpful resources

T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors