Forum Discussion
Solved
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 p...
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.
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 =
Completions =
SUMX(
Programs,
MIN(Programs[Goal], Programs[Completed])
)
2.For in complete status
Incompletions =
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.
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.
