I need to see different prices for different orders based same material separately

[Anonymous]

Hello ,

I have 2 files. First excel is for orders, materials, prices of materials. for each order material price can be different. other file has available stock.

my problem is, when I try to see total stock availability price for each order. Power BI calculates based on total stock availability, but I need to see price only for that order. I am sharing a snapshot what I mean. on the right side you can see seperate stock availability for same material.

If I do not summarize stock availability I see same lines for each stock

Thank you in advance

Baris 

[Anonymous]

Hi @Anonymous 

Can you provide some sample data that hide your private information and the output you want so that can provide more infotmation for you. you can upload the file to onedrive then put the file url to the post.

Best Regards!

Yolo Zhu

[Anonymous]

Hi @Anonymous 

I shared the link with you on your DM

Thank you 

Baris 

[Anonymous]

Hi 

were you able to check?

Thank you

Baris 

[Anonymous]

Hi v-xinruzhu-msft

I can not use onedrive due to restrictions in my pc from company rules. 

May you give me your e-mail from DM ? I can share dthe sample data for you

Thank you in advance

Baris 

[Anonymous]

I have just sent.

Thank you

Baris 

[Anonymous]

Hi,

did you get my e-mail?

[Kedar_Pande]

To fix this, make sure you're using relationships correctly between the two files. You need to link the order to its specific material and price in the orders table. Then, create a measure for calculating the stock price for each order rather than summarizing total stock.

Use SUMX or a similar function to calculate the price for each row based on the order material and quantity, so Power BI doesn’t summarize stock across all orders.

[Anonymous]

Hello Kedar,

actually I create the relation between materials. but if you want I can share Power BI file with you?

if yes may you share your e-mail with me?

Thank you

Baris 

[Kedar_Pande]

@Anonymous Share the file - kedarpande19@gmail.com

[Anonymous]

Hello Kedar,

were you able to check?

Thank you

Baris 

[Anonymous]

Hi Kedar,

were you able to check?

Thank you

Baris