How to multiply Measure with Fixed value from different table

[Anonymous]

Hi everyone,

I've made the following table containing two items from the "Master" data sheet with product facts (Product Gegevens); ProductID and PurchasePrice. Also I've created a Running Total Measure "Totaal Voorraad". I'd like to multiple this measure (middle column) with the right colum (purchase price). The following formula won't be accepted, hence I've tried to use RELATED and RELATEDTABLE in order to make it work. This didn't do the trick unfortunately.... 

Does anyone has a solution for this issue?

Tyson.

[Anonymous]

@Anonymous 
What is the relationship between the 2 tables, connect by which field? Is it possible to share the sample pbix.

Paul

[Anonymous]

Hi @Anonymous / Paul,

Thanks for your question. I'm not able to share a pbix file with you. However, I can send you this screenshot of the corresponding model. They're connected via the ProductID.

[lkalawski]

Hi @Anonymous 

Measure =
[Totaal Voorraadd] * SELECTEDVALUE ( 'Product Sales'[Purchase Price] )

You must use the SELECTEDVALUE or MAX function to determine which row (which value) you want to multiply. 

_______________
If I helped, please accept the solution and give kudos! 😀

[Anonymous]

Hi Ikalawski,

Thanks for your feedback, but it doesn't work yet. Both the table containing al ProductID's and the table with one ProductID sorted by date does not show a total stock value correctly.