Forum Discussion

agius's avatar
agius
Regular Visitor
6 years ago
Solved

Creating a Measure by using a fixed value

Hi,   I need to create a simple measure but cannot seem to make it work. I need to divide 2 columns and then multiply the answer by 100. So it looks something like this:   CTR = (Clicks / Impress...
DAX
Help
Help with DAX Measure
measure
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    agius 

     

    Finally, I figured out your issue.

    If you want to change the decimal number to percentage, you can't multiple 100 in the coding. That will make the result be larger.

    You need to choose the measure and change to percentage format.

agius's avatar
agius
Regular Visitor
6 years ago

ryan_mayu This is great! Thanks 🙂

 

This solves this issue. But I have similar situations where i need to multiply by a fixed number. I find it hard to believe how it is not possible to multiply by a fixed number. Maybe, I can just add a column with this fixed value and multiply my answer to it. I guess that might work. If you know of any easier solution please let me know 🙂

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

agius 

Please provide the screenshots or demo file. Let me know what the expected result as well.

 

Thanks and BR

Ryan