Divide by total

[OptimusLime]

Hi

Really new to this. I'm trying to get each row to divide by the total of the column and not line by line. 

I keep getting:

I'm trying to get:

Really appreciate any help you have. 

Thanks

[jdbuchanan71 · Accepted solution]

Hello @OptimusLime 

What you need to do is tell your calc you want the sum of BOE from the whole table like so.

Amount divided by BOE =
DIVIDE (
    SUM ( YourTable[Amount] ),
    CALCULATE ( SUM ( YourTable[BOE] ), ALLSELECTED ( YourTable ) )
)