Need help with DAX Measures

[saud968]

1. Target status label = IF([Actual vs Target %] >= 100, "Met the Target", IF([Actual vs Target %] > 100, "Above the Target", "Below the Target"))
2. Actual vs Target Label = ABS([Actual vs Target %])
3.Acheived % = MIN( 1 + [Actual vs Target %], 1)
4. Remaining % = MAX( - [Actual vs Target %], 0)
5. Avg_CSAT_Score = Calculate(Average('SUPPORT__CW_OPS_CES_CSAT_PARTNER_CARE_TEMP'[NUMBER_VALUE]),'SUPPORT__CW_OPS_CES_CSAT_PARTNER_CARE_TEMP'[QUESTION_NAME]="How satisfied are you with the overall service you received today from the Team?")
6. Actual vs Target % = ([Avg_CSAT_Score]/4.0).

Current actual vs target % is 106.77%, the measure 1 and 2 are not working as it supposed to I am working in Power BI. Also, Target Sales Label is showing "Below the Target" although the actual vs target is 106.77%

Please help @amitchandak @Greg_Deckler @v-robertq-msft @Migasuke @Idrissshatila 

I am trying to create similar to this

[saud968]

I think I found my fix for one of them. 

Target status label =

IF([Actual vs Target %] >= 100, "Met the Target",

   IF([Actual vs Target %] < 100, "Above the Target", "Below the Target"))

I still need help with Actual vs Target Label = ABS([Actual vs Target %]) Current actual vs target % is 106.77% the result should 6.77% but it is showing 106.77%

[saud968 · Accepted solution]

I figured out the issue, it got fixed by using 

Actual vs Target % = DIVIDE([Avg_CSAT_Score]-[A CSAT Target],[A CSAT Target])