Forum Discussion

OptimusLime's avatar
OptimusLime
New Member
7 years ago
Solved

Divide by total

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

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

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

     

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    7 years ago

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