Forum Discussion

WWC2024's avatar
WWC2024
Frequent Visitor
1 year ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
    WWC2024
    Frequent Visitor
    1 year ago

    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's avatar
      WWC2024
      Frequent Visitor
      1 year ago

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