Return count from filter

[Durbslaw]

Hi,

I have the following incorrect DAX measure (it should return a count of PersalNo for the filter African Males)

CountOfAfricanMales =
var filtered=
FILTER(
Demographics,
Demographics[Race]='African' &&
Demographics[Gender]='Male')
return
SELECTCOLUMNS(COUNT(
filtered,
"African Male",
'Staff Management'[CountOfPersalNo])
)

[Tahreem24]

@Durbslaw Can you able to share sample data (copy paste here)?

[Durbslaw]

I think i have it...

CountOfAfricanMales =
var filtered=
FILTER(
Demographics,
Demographics[Race]='African' &&
Demographics[Gender]='Male')
return
CALCULATE(
[CountOfPersalNo],
filtered)