Forum Discussion

AColeman's avatar
AColeman
Frequent Visitor
9 years ago

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 m...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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. :smileyhappy:

 

Regards

  • AColeman's avatar
    AColeman
    Frequent Visitor
    9 years ago
    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