Calculate column sum and Measure Sum is different.

[mohittimpus]

When I mutiple two column and divid by 100 this will give correct result in calculate column.

When I doing same thing in Measure then I got wrong result. 

Net Column = 'Skyline-SpinData'[Bet]*'Skyline-SpinData'[Lines]/100

Net Measure = SUM('Skyline-SpinData'[Lines])* SUM('Skyline-SpinData'[Bet])/100

Next Measure =

Var A = SUMX('Skyline-SpinData','Skyline-SpinData'[Lines])

var B = SUMx('Skyline-SpinData','Skyline-SpinData'[Bet])

Var c = A*B

Return

DIVIDE(C,100)

Power BI file: https://1drv.ms/u/s!AswA2ZDrJCDcyXQmB8ecQ7fAy5SW?e=Nfj99W

[mahoneypat · Accepted solution]

You were on the right track with the use of SUMX.  SUMX is an iterator and can give you the calculated column result but dynamically.  Please try this measure instead

Next Measure =
DIVIDE (
SUMX ( 'Skyline-SpinData', 'Skyline-SpinData'[Lines] * 'Skyline-SpinData'[Bet] ),
100
)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[amitchandak · Accepted solution]

@mohittimpus ,

Divide should be Sum(A)/Sum(B)

Multiplication should be sum(A*B)

Net Measure = SUMX('Skyline-SpinData','Skyline-SpinData'[Lines]*'Skyline-SpinData'[Bet])/100

Next Measure =
Var A = SUMX('Skyline-SpinData','Skyline-SpinData'[Lines]*'Skyline-SpinData'[Bet])

Return
DIVIDE(A,100)

[mahoneypat · Accepted solution]

You were on the right track with the use of SUMX.  SUMX is an iterator and can give you the calculated column result but dynamically.  Please try this measure instead

Next Measure =
DIVIDE (
SUMX ( 'Skyline-SpinData', 'Skyline-SpinData'[Lines] * 'Skyline-SpinData'[Bet] ),
100
)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat