Forum Discussion

AC23VM's avatar
AC23VM
Helper II
1 year ago

Z-Score calculation error in DAX?

VC_Yes_Flag = IF( 'Outcomes Testing Data'[Vulnerable Customer] = "Vulnerable Customer", 1, 0 )   Grading_Numerical_Column = SWITCH( TRUE(), 'Outcomes Testing Data'[Overall Journey Grading A-E] = ...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

Likely this part

Mean_Harm_Vulnerable = 
CALCULATE(
AVERAGE('Outcomes Testing Data'[Grading_Numerical_Column]),

 

You would need to replace that with COUNTROWS across all categories. 

AC23VM's avatar
AC23VM
Helper II
1 year ago

I don't understand, lbendlin, sorry.  I can't replace the CALCULATE with COUNTROWS because then I'm not getting the mean.  But I also can't add in COUNTROWS because then it's too many arguments. 

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi AC23VM,
    Thanks for reaching out to the Microsoft fabric community forum.

    The issue seems to come from a mismatch between what you're trying to measure and how the DAX is written. Right now, the calculation takes an average of numbers that were assigned to each grading category. But those numbers are just labels, not real values you can average in a meaningful way. So, the DAX treats them like actual measurements, which leads to incorrect results.




    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thanks and Regards