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.

AlB's avatar
AlB
Community Champion
6 years ago

Hi agius 

So what is the problem exactly with the measure that you put together? You just need to multiply by 1000 but other than that it looks fine, given the info provided.

 

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers