Issue with current measures. I need to measure progress.

[mehlenbae2]

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 AP reached 100% of their target. Previously, AP's target was not met so my "Pending" and "Completed" measures worked just fine, now that the target is met my AP visuals look weird. 

The targets for each region is as follows:

AP = 950

NA = 1250

UK = 250

I used two different measures to craft my bar charts- Refresh Completed and Refresh Pending.

Refresh Completed = SUM('Refresh'[Count])

Refresh Pending = SELECTEDVALUE('Refresh'[Target]) - 'Refresh'[Refresh Completed]

I had a response to my issue that said to use a measure like: Sumx(Summarize('Refresh', 'Refresh' [region] ,"_trg", Max('Refresh'[Target]),"_cnt",SUM('Refresh'[Count])) , [_trg] -[_cnt])

However, I got the following results:

It still doesn't work. Please help!

[TomasAndersson · Accepted solution]

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]

I have a follow up question- so it works almost perfectly, the only thing that I would like to modify is that in my bottom left visual, I'd like it to display the deployment targets for each region (AP's deployment target is 950) but because AP surpassed the target it now shows the total deployments and not the target. Is there a way to modify this? Everything else works perfectly, though!

[mehlenbae2]

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