Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Divide column value by another value in same column

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"))
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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")) )