Forum Discussion

AOD's avatar
AOD
Icon for Helper III rankHelper III
5 years ago

In correct total in calculated Column

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.

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    AOD , Please create a measure like this for calculation

    calculated =

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