Divide column value by another value in same column

[Anonymous]

gross sales is just like other values in that account column.
The calclation i am using this.

DIVIDE(CALCULATE(SUM(Mockup[Forecast (Act+Est)]),Mockup[Account]),CALCULATE(SUM(Mockup[Forecast (Act+Est)]),Mockup[Account]="Gross Sales"))

[amitchandak]

@Anonymous , This one should work

DIVIDE(CALCULATE(SUM(Mockup[Forecast (Act+Est)])),CALCULATE(SUM(Mockup[Forecast (Act+Est)]),Mockup[Account]="Gross Sales"))

or

DIVIDE(CALCULATE(SUM(Mockup[Forecast (Act+Est)])),CALCULATE(SUM(Mockup[Forecast (Act+Est)]),Filter( allselected(Mockup) , Mockup[Account]="Gross Sales")) )