Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating a Measure to multiply each row by certain values

Hello, 

 

Im struggling with multiplying each row of my table with a multiplier which are 2 different measures I have ready. What is the best function to use to multiply each row with a certain value? And what is the appropriate formatting?

 

Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    HI Anonymous 

    Try this, if your certain value is 50 and:

     

    Measure =
    Max ( table[Walking time for 1 bin] ) * [your Measure] * 50

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

2 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    HI Anonymous 

    Try this, if your certain value is 50 and:

     

    Measure =
    Max ( table[Walking time for 1 bin] ) * [your Measure] * 50

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi VahidDM 

       

      Thank you for your help! It has worked. Im curious to understand how the MAX function worked in this context. Isn't the MAX function supposed to only take the one biggest value in the column? How has this calculation applied to each row?

       

      Cheers.