How Do I Create Cost Per Click In Power BI

[lparks]

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.

[amitchandak · Accepted solution]

@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]))