Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Below is the relationship for this model
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.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |