How do I create a new column that divides one column by another to get a percentage? For example, for email marketing, the number of email opens divided by email deliveries equals open rate.
I created a column that shows the value, but it is not a percentage and the bottom is a sum total, rather than continuing the division calculation on the total number of opens and deliveries.
I did some research and came up with this measure, but I'm getting an error message.
Hi @SirJJAnderson ,
Measures are diferent from calculated columns, you have to write your calculation using aggregators.
This case should be like:
Measure = DIVIDE(SUM(TABLE1[Opens]); SUM(TABLE[Deliveries]))
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
