Forum Discussion
Need help with DAX Measures
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
I figured out the issue, it got fixed by using
Actual vs Target % = DIVIDE([Avg_CSAT_Score]-[A CSAT Target],[A CSAT Target])
2 Replies
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%I figured out the issue, it got fixed by using
Actual vs Target % = DIVIDE([Avg_CSAT_Score]-[A CSAT Target],[A CSAT Target])