Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AColeman
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.

 

Visualization

 

Any help will be appreciated.

2 REPLIES 2
v-ljerr-msft
Employee
Employee

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

 

Regards

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

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.