Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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]))
@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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |