Top performer per case

[setis]

Dear all

I have a list op activities and I'm trying to identify the user with most activities per case. If there are 2 users with the same top nr of activities, they can share the top. 

I need this on a calculated column on the table. 

This is an example of the table and the expected result:

Type	Case	User	Expected
Email	111	A	1
Email	111	A	1
Email	111	B	2
Email	111	C	2
Email	111	D	2
Email	111	A	1
Email	122	A	2
Email	122	B	1
Email	122	B	1
Email	122	C	2
Email	122	D	2

Thank you in advance!

[setis]

@amitchandak thanks a lot, this is what I was looking for. 

[amitchandak · Accepted solution]

@setis , Create two columns like

Activity = countx(filter(table,[Case] =earlier([Case] && [User] =earlier([User] )),[User])

rank = rankx(filter(table,[Case] =earlier([Case])),[Activity],,desc,dense)

For Rank Refer
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns