Summing columns instead of individual items

[#1]

Hi,

I'm having trouble when I try to sum one whole column. The outcome is that it's performing a calculation line by line instead of on the two summed columns.

My expression is:

***************************************************************************************

sum({<Registration_Code={'2'},YMDate=DisplayYM>}[Total_proceeds])

/

sum({<Registration_Code={'2'},YMDate=DisplayYM>}[Market_Value]

**************************************************************************************

Instead of summing Total_proceeds and Market_Value and dividing the two totals, it's summing line by line and performing the division calculation on each line which is giving me an incorrect answer.

What should I be doing differently?

Thanks 🙂