Forum Discussion
How Do I Create Cost Per Click In Power BI
I created a simple formula to get cost per click metric which is cost / click.
This is the formula I have Cost Per Click = DIVIDE ( 'Append1'[Total cost],'Append1'[Total Clicks]), but the answer is not correct. Can someone help me.
Total clicks = 5214
Total Cost = 15,428
Cost Per Click should be 15428 / 5214 = $2.95 but I'm getting the answer $194.19 with the formula above. Can anyone help me with the correct formula? I'm new to Power BI so not sure how it all works.
lparks , Try a measure like , Assuming [Total cost] and [Total Clicks] are columns
Cost Per Click = DIVIDE ( Sum('Append1'[Total cost]),Sum('Append1'[Total Clicks]))
1 Reply
lparks , Try a measure like , Assuming [Total cost] and [Total Clicks] are columns
Cost Per Click = DIVIDE ( Sum('Append1'[Total cost]),Sum('Append1'[Total Clicks]))