Calculate number need to achieve target %

[Creative_tree88]

Hi all - I have a dataset which looks at performance or marking papers within a target timeframe of 7 days (<= 7 days).  I compare 'this week' to 'last week' in terms of %.  I have all the required %'s in terms of showing what % is this week, and the % last week.  What I'd like to calculate though, is the number needed from this week to have achieved the target of 70%.

So, for example, if this week was 68% - then 2% needs to obivously be added but I'm not sure how to calculate this in terms of the number in the data to get to that 70% target.

The sample data demonstrates what I'm trying to say, as well as providing the basic fields I have in my dataset to work with.

'This Week' is a changing number as the report is refreshed daily, so the % will change on a daily baisis.  The reason for adding the calculation required to reach 70%, is because it will provide an actual 'live' number at that point in the week, in terms of what the examiners need to do to get to 70%, otherwise they don't really know until it's too late for the next week's target.

Sample data linked - let me know if you need more clarification.

Sample Data 

[Anonymous · Accepted solution]

Hi @Creative_tree88 ,
Thanks for parry2k reply.
Let's say you have a table called Papers that contains TotalPapers and MarkedPapers columns.
You can create a mesure

NeededToTarget = 
VAR CurrentPercent = DIVIDE(SUM(Papers[MarkedPapers]), SUM(Papers[TotalPapers]), 0) * 100
VAR TargetPercent = 70
VAR TotalPapers = SUM(Papers[TotalPapers])
VAR CurrentMarkedPapers = SUM(Papers[MarkedPapers])
VAR TargetMarkedPapers = (TargetPercent / 100) * TotalPapers
VAR NeededPapers = TargetMarkedPapers - CurrentMarkedPapers
RETURN NeededPapers

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[parry2k]

@Creative_tree88 Not sure if I understood but maybe this is what you need:

Required % = 
.7 - [Your Existing % Calculation Measure]