Forum Discussion
MIKAOKSA
6 years agoHelper I
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 displaye...
- 6 years ago
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!
Anonymous
6 years agoNot applicable
Try this
Osuuden tavoiteaika =
SUMX('REP_EMPOPERATWR_MV','REP_EMPOPERATWR_MV'[Työn tavoiteaika]) * [Osuus työlle %])
Thanks,
PRavin