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