Forum Discussion

mehlenbae2's avatar
mehlenbae2
Icon for Helper II rankHelper II
3 years ago
Solved

Issue with current measures. I need to measure progress.

I put together two visuals that measures a project that my team has been working on. However, AP has reached 100% of their target which is deploying 950 systems. I would like for my chart to display ...
Need Help
  • TomasAndersson's avatar
    TomasAndersson
    3 years ago

    Hi!
    At least a part of the issue seems to be that the number of refreshed can exceed the target. You can remove "Pending" when target is met by adding an IF() clause

    Pending = 
IF('Refresh'[Refresh Completed] >= SELECTEDVALUE('Refresh'[Target]), //If reached target
    0,    //Nothing is pending
    SELECTEDVALUE('Refresh'[Target]) - 'Refresh'[Refresh Completed]  //Else calculate pending
)

    Depending on if you want to restrict Completed to not being higher than target, you could do something similar for that measure

    Hope this helps!

TomasAndersson's avatar
TomasAndersson
Icon for Solution Sage rankSolution Sage
3 years ago

Hi!
At least a part of the issue seems to be that the number of refreshed can exceed the target. You can remove "Pending" when target is met by adding an IF() clause

Pending = 
IF('Refresh'[Refresh Completed] >= SELECTEDVALUE('Refresh'[Target]), //If reached target
    0,    //Nothing is pending
    SELECTEDVALUE('Refresh'[Target]) - 'Refresh'[Refresh Completed]  //Else calculate pending
)

Depending on if you want to restrict Completed to not being higher than target, you could do something similar for that measure

Hope this helps!

mehlenbae2's avatar
mehlenbae2
Icon for Helper II rankHelper II
3 years ago

Wahoo! Thank you very much, Thomas. This worked perfectly.