Forum Discussion
Solved
SUM doesnt work
I have a problem in summing calculated values. I have this calculated value:
Osuuden tavoiteaika =
SUM('REP_EMPOPERATWR_MV'[Työn tavoiteaika]) * [Osuus työlle %]
When lines are displayed individually the numbers are correct but when I try to get to single value the calculations are a bit off. I suspect this has something to do with the "[Osuus työlle %]" not being a sum value but it is a percentage value and I dont think it should be summed, there has to be something else. I am a beginner so please, help eventhough this is propably super simple.
Also, how do I insert Pictures on these messages? Would make explaining so much easier.
Hi MIKAOKSA ，
9.58 is the result of sum(9.67,14.33) * devide( sum(4,73,2.66),sum(5.93,12.59)), as measure is used in context,it will also calculated in the total field, not only simply sum the rows in the column.
I have 2 suggestions for you:
1.convert the other measures to calculated columns, and you will see :
2. modify your measure as below:
Goal time on own part = var a = SUMMARIZE('Table (2)','Table (2)'[Index],"A",SUM('Table (2)'[Time on work/Employee])/SUM('Table (2)'[Total completion time of work]),"B",SUM('Table (2)'[Goal time whole work])) return SUMX(DISTINCT(a),[A]*[B])And you will see:
Here is my .pbix file.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
6 Replies
Hi,
thank you for your quick response. How ever, that did not solve the problem, it gives the exact same answer as before adding that formula.
Situation including work, should add up to 10,74.......but doesnt.
