Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to multiply Measure with Fixed value from different table

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 ...
Need Help
lkalawski's avatar
lkalawski
Resident Rockstar
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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.