Forum Discussion
saud968
Memorable Member
Memorable MemberNeed 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 %...
I figured out the issue, it got fixed by using
Actual vs Target % = DIVIDE([Avg_CSAT_Score]-[A CSAT Target],[A CSAT Target])
saud968Memorable Member
Memorable MemberI 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 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
I figured out the issue, it got fixed by using
Actual vs Target % = DIVIDE([Avg_CSAT_Score]-[A CSAT Target],[A CSAT Target])