Forum Discussion
Solved
Divide By Different Aggregations
Hello, Apologies as I am still new to PowerBI. How can I get a divided measure based on 2 fields (Week and Channel)? For example I have: For CPC, I would like Act-Spend/Act-Clicks, which is w...
How is your average measure defined? If you define it as DIVIDE ( [Act-Spend], [Act-Clicks] ), then you should be fine (assuming you've already defined each of those measures).
Hi,
Use these measures
Spend = sum(consol[Act-Spend])
Clicks = sum(consol[Act-clicks])
CPC = divide([spend],[clicks])
Hope this helps.
Thank you to both. I realized that I was using it as columns instead of measures, which was the issue.
Both solutions work, just needed to use it as a measure.
Thanks again!
- Ashish_Mathur
Super User
You are welcome.