Forum Discussion

lparks's avatar
lparks
Regular Visitor
4 years ago
Solved

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

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

amitchandak's avatar
amitchandak
Super User
4 years ago

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