topic Re: execution performance in Developer

execution performance

WWC2024 — Mon, 21 Apr 2025 21:55:39 GMT

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

Re: execution performance

Deku — Tue, 22 Apr 2025 04:47:47 GMT

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

Re: execution performance

Anonymous — Tue, 22 Apr 2025 05:42:37 GMT

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.

Re: execution performance

WWC2024 — Tue, 22 Apr 2025 20:55:05 GMT

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]

)

Re: execution performance

WWC2024 — Thu, 24 Apr 2025 03:11:29 GMT

solve the "total row " is very interesting question. Believe many are facing the same problems.