Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try this,
Count( {< Gender={'Male'} >} DISTINCT ID)
It's working for me.
Nik