Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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)
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)
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
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.