execution performance

[WWC2024]

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:

1. If the completed number exceeds the goal number, only the goal number should be counted.

2. 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

[v-pagayam-msft · Accepted solution]

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.

[WWC2024]

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]

    )

)

[WWC2024]

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

[Deku]

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