Hi all,
I'm working with a fairly large survey data set and am just struggling slightly with finding a way to categorize respondents into certain groups depending on their response choice.
The response options include ADHD, OCD, VisualImpairment, MotorImpairment, Dysgraphia, and Dyslexia.
The respondents might have duplicate rows, so I would like to categorize any respondent who chose either ADHD or OCD into Group 1, and respondents who chose anything else into Group 2 (using DAX)
I know I need to use the Filter function, but not quite sure how to nest it.
I've attached a workbook which will hopefully provide further clarity.
Any help/advice is greatly appreciated!
Currently using Office 365 ProPlus
Darko
I'm a little confused. You say "I would like to categorize any respondent who chose either ADHD or OCD into Group 1, and respondents who chose anything else into Group 2 (using DAX)", but in your sample file you have ADHD and OCD in Group 1 and Group 2.
My initial thought is that you should have a dimension table that maps the DxGrouping into group numbers, but that wouldn't work if one DxGrouping can be in two groups, so I await your clarification.
Mynda
