Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 / Impressions) * 100
So far I managed this much
Solved! Go to Solution.
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.
Proud to be a Super User!
Did you get an error message or not get the expected result?
The brackets in your formula is not correct. Is that a typo error?
CTR =
(DIVIDE(
SUM('Adform - Daily'[Clicks]),
SUM('Adform - Daily'[Impressions)]))
)
Proud to be a Super User!
@ryan_mayu Your suggestion helped! However, I still need to multiply by 100. I do not receive any error but I do not have the expected results.
@AlB Now, I have this
CTR =
(DIVIDE(
SUM('Adform - Daily'[Clicks]),
SUM('Adform - Daily'[Impressions)]))
) *100
But it doesn't work. Any suggestions? 🙂
Could you please provide some screenshots or demo file?
What's your expected results and what result you are getting now?
Thanks and BR
Proud to be a Super User!
@ryan_mayuI have the below and i need to have the (Total of Clicks / Total of Impressions) *100.
However, I cannot use the calculated fields as it takes the average instead of sum and then divide. For the below, the answer would be 0.42%. But obviously, I have larger dataset.
Hope this helps 🙂
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.
Proud to be a Super User!
@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 🙂
Please provide the screenshots or demo file. Let me know what the expected result as well.
Thanks and BR
Ryan
Proud to be a Super User!
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |