Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Numbers in equations

In a powerbi measure can I use numbers to be multiplied by columns.

 

for example: count(Total[total hired])*(2,000)

 

it is not working as I have it but is there a way to have it work?

 

 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Can I have a number within a measure that is multiplied by something else:

    for example:

     

    Count(Total[total hired])*(2,000) 


    That equation did not work but hopfully if gives you an idea. 

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI Anonymous

     

     

    When you say it isn't working.  Are you getting a result that is different from what you are expecting?  Or are you getting an error?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I am getting an error. 

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

    If there's actually a comma in 2,000, try removing it

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      thank you that was the issue, lol simple fix..