Need Help to find headcount latest divsion

[Anonymous]

Hai All Need your help on this
The requirement is Want to find the headcount of the Latest Division, I Had already found the Latest division. But the requirement is not completed for example
I Have Column Like

Latest Divison

ABCDEFGHI

I want to take count of these corresponding latest division values.
Please help me

[v-cazheng-msft · Accepted solution]

Hi @Anonymous ,

Not very sure about what the table looks like in your model. Please try the following formula.

Useremail Count =
CALCULATE (
    COUNT ( [email column] ),
    FILTER ( 'table name', [division column] IN [Latest Division] )
)

If it doesn’t work, could you please provide some sample data in your tables and tell me the relationships between them so I can help you find a solution?

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

I Have a column Called Latest Divison,
Expecting output is 

Latest Divison	Useremail COunt
ABCDEF@GMAIL.COM	15
EFGHI@GMail.com	20
HIJKL@GMAIL.COM	25

[BeaBF]

@Anonymous  ok, the expected output is clear, but can you paste some data on which you want to calculate this result? 

Thx,

BF

[BeaBF]

@Anonymous Hi!

Can you paste some sample data? 

Thx,

BF