How to get percent of userIDs having more than 1 sessionIDs

[Anonymous]

Hello,
I want to calculate the percentage. 
How many percent of USERIDs have more than 1 SESSIONIDs.

For example: If I have 10 UserIDs with 2 sessionIDs against each of them. So the answer will be 100% of the user IDs have more than 1 session IDs.

Can you help me with a measure or formula to calculate above example on a large dataset.

Regards,
Aditya

[Anonymous]

Hello @amitchandak Thanks for the solution.

[amitchandak · Accepted solution]

@Anonymous ,Try measure 

Count = count(Table[Session])

divide(Sumx(filter(Values(Table[USer]), [Count] >1) , [User]) , countrows(Values(Table[USer])) )