Sum of the calculated column is wrong when i multiply Measure * Measure

[reddychohan]

Hello community - Recently i've was struck in a calculation where i try to create new column based on one measure multiplied into another the values i am getting is wrong

here when i try to multiply ratio of capacity * sum of story point 1 --- the result i am getting is CAL column listed behind it 

the formula i'used to create CAL ---  

CAL = SUMX('Get Issue Details',[ratio of capacity]*('Get Issue Details'[Story Points]))

any help is much appreciated

[reddychohan]

@Anonymous thanks for the solution 

[Anonymous · Accepted solution]

Hi @reddychohan ,

I have created a simple sample, but I cannot reproduced the issue.

Could you please provide some sample data or pbix file without privacy information and desired output?

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.