Ethnicity- Multi resulting in error
I am trying to decode the multiple option selected in the race condition used: COUNT(DISTINCT "Worker"."Employee Ethnicity Code" by "Worker"."Person Number") > 1 THEN 'Two or More Races' ELSE "Worker"."Employee Ethnicity"
However, when i remove the person.ethnicity column, No fact table exists at the requested level of detail. How do I fix this one. I do not need the multiple rows per person.