Count Values not working as desired

[Quakker]

Hi,

currently i am struggeling within Power BI Desktop.

My goal is...

I want to create a measure which counts the amount of names within my dataset and depending on the amount it should give an output.

For example.

If there are 3 or more distinct names within my table (after filtering using slicer). The Measure should return the Amount of names.

If there are 2 or less distinct names within my table (after filtering using slicer). The Measure should return "blank()".

The screenshot shows, that i am using a slicer. I receive an amount of remaining rows of 4.

Nevertheless the pie chart dont order the 4 values to the gender they have. I assume that the amount of names measure will be calculated on a row level? Any1 an idea how to fix it that the pie chart orders the 4 rows to their gender?

Here the Measure dax:

And Dax Dimension:

Name	City	Sex	Country
Meier	Berlin	m	Germany
Müller	Berlin	m	Germany
Austerjost	Berlin	m	Germany
Graf	Hamburg	m	Germany
Brand	Madrid	m	Spanien
Strothoff	Madrid	m	Spanien
Kramer	Barcelona	w	Spanien
Modeste	Porto	w	Portugal
Federer	Liverpool	w	England

Thanks already for your help.

[v-yinliw-msft · Accepted solution]

Hi @Quakker ,

Is that what you expect?

If so, you can do this:

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.