Forum Discussion
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...
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)]))
)
Could you please provide some screenshots or demo file?
What's your expected results and what result you are getting now?
Thanks and BR
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 🙂