Genderdistribution within a cluster.

[Snorlaire]

Hey!

I am trying to create a view that shows the gender distribution within a cluster.
The dataset that I'm using for this has employees connected to clusters, but I am unable to split the genders.

So the end goal is this, but all I am getting is a count of male and female together, instead of them being split.

Thanks in advance!

[Taoufiq_Zarra]

can you share a sample data ?

[Snorlaire]

This is the data used. It is a view pulled from the Adventurework sample database by Microsoft. 

I am unsure if the picture added to this message is readable, so Ive attached the same file to the message.

[Taoufiq_Zarra · Accepted solution]

@Snorlaire  if I understood correctly, you have to add this set to your expression...
for men

{<Gender={'M'}>}

for women

{<Gender={'F'}>}

for example count({<Gender={'F'}>} NationalIDNumber) ....

if not, can you share the expected output from this sample (if possible a sample in excel or text format)