Ethnicity vs Race
Hello I am new to this system and I am looking to create a variable that says if the candidate selected Not Hispanic or Latino, then count race they selected. If the candidate selects Hispanic or Latino, then do not count any other race selections. So far I have the below and Its not working.
=If([Candidate Ethnicity (EEO2)]="Hispanic or Latino";"Hispanic or Latino";[Candidate Race (EEO2)])
Measures continue in the below format for each race
=Count([Candidate ID])Where([Candidate Ethnicity (EEO2)]="Black or African American")
I am missing somehthing big, what is it?