Forum Discussion
How to Create Calculated Column/Measure as a Percentage
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 cr...
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]))
Got it! I'm a total noob, appreciate your help here!