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.
AlexisOlson
Super User
Super UserHow 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).
Yes, that's exactly how I have it:
CPC = DIVIDE((consol[Act-Spend]),(consol[Act-Clicks]))
It works for each of the channel, but the rolled up view still is an average of the fields underneath.
- Ashish_Mathur
Hi,
Use these measures
Spend = sum(consol[Act-Spend])
Clicks = sum(consol[Act-clicks])
CPC = divide([spend],[clicks])
Hope this helps.