Dax Measure Help | Getting total produced cost of my final output.

[mmfp]

Hello guys, 
Let me try to explain what I need to achieve...
I have a Fact_Inventory table. In this table there is a column name "transaction_type", when thar field = "MO", I get the manufacture orders. 
Granularity of this tables from higher to lowest = referenceid (in this case "MO-0001")<, batch (lote), < serial (serie). 

When I filter by a Manufacture Order, there are inputs and outputs. Different serial and batch generates a different batch and serial.

I also have two dimensin tables, batch_produced and serie_produced, because then I have the revenue by each batch and serie sold and I would like to see margin.

I would like to achieve the cost of the inputs by output batch or serie , to get the product margin of that batch or serie.

For example, in the photo. That's a Manafucture Order. I would like to ble able to get the total sum of the blue cost when I put in a different table the lote or serie (the produced product) the one that are in green.

Example

Thank you in advance.

Spoiler

[mmfp]

Hello, any news on this topic? Thank you.

[Anonymous]

Hi @mmfp ,

I can not help you very well. Maybe you can provide me with your pbix file?

Please remove sensitive data and do not log in to your account in Power BI Desktop when uploading pbix files.

All this is to better solve your problems.

I would be grateful if you get back to me quickly.

Best Regards,

Clara Gong

Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[mmfp]

Hello, here is the power bi example:
https://www.dropbox.com/scl/fi/g0gr88snpnlmjxz97ufad/cost_example.pbix?rlkey=x18pyowb14pa70oyn68f5e6...
I would like to be able to know the total cost of production (statusissue = 1) when I see information by produced items (statusreceipt = 1) . 
There is an example in the file. 

Thanks in advance.

[Anonymous]

Hi @mmfp ,

I have received your document, but unfortunately, I do not understand your needs. I hope you can describe it in more detail below.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mmfp]

Hello,

I have updated the pbix.file with the explanation.

Here you have it in a screenshot too.

Here you have the link: 

https://www.dropbox.com/scl/fi/1yus5vc2nd5h4euydk7h3/cost_example.pbix?rlkey=llssk44qhviub422fwq9ebo...

Thank you.