Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 ) ) )
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 ) ) )