Creating Graph that shows attainment on a target

Hello norken20,

Do you want something like this?

Hello norken20,

You can create a measure as below:

Target yet to achieve = 
VAR SalesValue = CALCULATE(SUM(Sales[Sales Value]),Sales[Status]="Posted")
VAR Target = SUM(TargetSales[Target Sales ])
VAR TargetToAchieve = Target - SalesValue
RETURN IF(TargetToAchieve<0,0,TargetToAchieve)

And use Sales and This measure in a stacked chart.

Let me know if this didn't help.

Hi norken20 ,

Please create two measures as below and add then to visual.

current attainment = CALCULATE(SUM('Table (2)'[Sales Value]),FILTER('Table (2)','Table (2)'[Status]="Posted"))

sales target = 
VAR target = SELECTEDVALUE('Table'[Target Sales ])-[current attainment]
return
IF(target<0,0,target)

Result would be shown as below.

 Pbix as attached.

Best Regards,

Jay

Community Support Team _ Jay Wang

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