In correct total in calculated Column

[AOD]

Hi all,

I have a new column in my Table 'Calculation' it is calculated as

( cases/Population)*100000

Row wise calculation is fine but the total of all is actually coming up as Sum of calculated column.

rather it should be as the formula for total as well.

Kindly help . thanks in advance.

[amitchandak]

@AOD , Please create a measure like this for calculation

calculated =

divide(sum(Table[cases]), sum(Table[Population]))*100000