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

Need Help

4 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

     

    Paul

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.