Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
WWC2024
Frequent Visitor

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:

  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

 

WWC2024_2-1745272465240.png

 

 

 

1 ACCEPTED SOLUTION
v-pagayam-msft
Community Support
Community Support

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.
vpagayammsft_0-1745299795126.png

If my anwer meets your requirement,consider accepting it as solution.

Regards,
Pallavi.

View solution in original post

4 REPLIES 4
v-pagayam-msft
Community Support
Community Support

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.
vpagayammsft_0-1745299795126.png

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.

  

Deku
Super User
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


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.