Forum Discussion

Nyarlathorep300's avatar
Nyarlathorep300
Regular Visitor
2 years ago

Computing chi squared in Dax - missing values

I have a regularly changing dataset, on which I'm trying to create a measure that computes chi squared statistics. I want a measure so the underlying data can be filtered and the statistic will be re...
Nyarlathorep300's avatar
Nyarlathorep300
Regular Visitor
2 years ago

That function requires the input X the sum ofvthe squares of the variation from the expected values, which is the number I'm  trying to compute.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
     If zero people in a ethnic group gave a particular LeavingFactor answer

    Is that because there were no leavers in that group or because they left but didn't fill the survey?

     

    You can consider using COALESCE to fill voids.