I have a table that I need to filter and display only the jobs that are not gender diverse

[ghoussoub]

I have a table that lists available open jobs with the candidates and the gender of each candidate.

I need to filter the table and display only the jobs that are NOT diverse and don't have at least 1 female and 1 male candidates.

So based on the table below only Job2 and Job3 will be displayed in the table because they DONT have at least 1 f and 1 m candidate.

Jobs	Candidates Gender	Candidates Gender
Job1	Job1 Candidate1	Female
Job1	Job1 Candidate2	Female
Job1	Job1 Candidate3	Male
Job1	Job1 Candidate4	Female
Job2	Job2 Candidate1	Male
Job2	Job2 Candidate2	Male
Job2	Job2 Candidate3	Male
Job3	Job3 Candidate1	Female
Job4	Job4 Candidate1	Male
Job4	Job4 Candidate2	Female

[AlB]

Hi @ghoussoub 

1. Place Table1[Jobs] in a table visual

2. Create this measure

ShowMeasure =
VAR genders_ =
    DISTINCT ( Table1[Gender] )
RETURN
    IF ( "Female" IN genders_ && "Male" IN genders_, 0, 1 )

3. Place the measure in the visual filter and select to show items when value is -->1

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB]

@ghoussoub 

or another version of the measure to do the same:

ShowMeasure V2 =
VAR numgenders_ =
     DISTINCTCOUNT ( Table1[Gender] )
RETURN
    IF ( numgenders_ = 2, 0, 1 )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlexisOlson]

Seems like you just need 

GenderCount = DISTINCTCOUNT ( Table1[Gender] )