The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a problem in summing calculated values. I have this calculated value:
Solved! Go to Solution.
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.
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.
Please share your sample data and expected output.
Time on work/Employee | Goal time on own part | Personal efficiency % | EMPID | WORKID | % of work | Goal time whole work | Total completion time of work |
4,73 | 7,71 | 163,07 | 1 | T0000 | 79,76 | 9,67 | 5,93 |
2,66 | 3,03 | 113,82 | 1 | T0001 | 21,13 | 14,33 | 12,59 |
Goal time whole work, Time on work/employee, total time of work come straight from data.
% of work =
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.
Thank you so much!! 🙂 I did the column thing and it seems to be working perfectly!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
109 | |
67 | |
46 | |
41 |
User | Count |
---|---|
186 | |
85 | |
76 | |
74 | |
56 |