Data count not reflecting correctly

[JoannaManibo]

I am using this formula "=Count({<[Gender]={'Male'}>}[Gender])" to get the total count per gender but the total count is not showing correctly. See the screen shot and correct total count per gender below:

Male: 4,439

Female : 4,583

[sunny_talwar]

The expression looks okay to me... would you be able to share a sample where we can see the issue?

[NitinK7]

hi,

can you provide data file for the same then it will be easy to find out what is problem

because your expression is looking correct

regards,

Nitin.

[Tanalex]

Any chance you have filters chosen somewhere else in the application?

[NitinK7]

No it is not a right way because sometime your data file have space or some additional symbol

so better to give your sample data file

[JoannaManibo]

Here's the sample data. 

[NitinK7 · Accepted solution]

Hi,

see below screenshots

in backend write script like

and in measure field  your expression like 

"=Count({<[Gender]={'Male'}>}[Gender])"

and

"=Count({<[Gender]={'Female'}>}[Gender])"

[JoannaManibo]

Tried the new script but it is still not reflecting the correct total count per gender

[NitinK7]

Hi

Use double qoate or bracket to date field 

"Date Received"

or

[Date Received]

it will be work

[JoannaManibo]

Got it! Thanks! But I'm still having issue in reflecting the correct total count per gender