Forum Discussion
execution performance
Dear all
I need assistance with a calculation involving goal and completed data, both of which are measurements.
I want to measure actual completions and incompletions (column D and E) for each program based on the following criteria:
If the completed number exceeds the goal number, only the goal number should be counted.
For example, in a particular case, the completion is calculated as 42, while the incompletion stands at 8.
Your guidance would be greatly appreciated.
Looking forward to your insights.Thanks
Hi WWC2024 ,
Thank you for reaching out to us!
I tried to recreate it with my sampe data.Used below measures:1.For complete status
Completions =SUMX(Programs,MIN(Programs[Goal], Programs[Completed]))2.For in complete status
Incompletions =SUMX(Programs,Programs[Goal] - MIN(Programs[Goal], Programs[Completed]))
Please refer the screenshot and file for clear understanding.
If my anwer meets your requirement,consider accepting it as solution.
Regards,
Pallavi.
4 Replies
- Deku
Super User
Completion =
Sumx(
Values( table[program]),
Var goal =
Calculate( sum( table[goal]))
Var complete =
Calculate( sum( table[complete]))
Return
If( complete > goal, goal, complete)
Incomplete=
Completion =
Sumx(
Values( table[program]),
Var goal =
Calculate( sum( table[goal]))
Var completion =
[completion]
Return
goal - completion
Hi WWC2024 ,
Thank you for reaching out to us!
I tried to recreate it with my sampe data.Used below measures:1.For complete status
Completions =SUMX(Programs,MIN(Programs[Goal], Programs[Completed]))2.For in complete status
Incompletions =SUMX(Programs,Programs[Goal] - MIN(Programs[Goal], Programs[Completed]))
Please refer the screenshot and file for clear understanding.
If my anwer meets your requirement,consider accepting it as solution.
Regards,
Pallavi.Dear Friend
total # in completions and incompletions are incorrect.
Since Goal and completed are measure, so I have tried the following dax and it works and wold like to share with you all.
1) get the goal exected adjust =
IF([Goal]>=[Completed],[Completed],[Goal])2) Goal Completed w/adj =if(HASONEVALUE('table" [program]),[goal executed adj],SUMX(SUMMARIZE('table','table'[program]),[goal executed adj]))solve the "total row " is very interesting question. Believe many are facing the same problems.
