Finding Rate that a number repeats itself in a column

[alexstock01]

Hello everyone,

I am working on a model that deals with payday loans. These loans are categorized by new loans and react loans. Reacts are when the customer is a returning customer. Basically, I am trying to find the rate at which a new loan turn to a react loan. My thought was to use the customers' social security number to figure this out. When I go through and filter the SSN column by a randomly selected SSN, I will see it only listed once if this certain customer only has 1 loan. If the customer has more than one loan, I see the SSN listed more than once. I also have another column that is categorized by "new" or "react" to go along with this. Also, customers can have more than 2 loans. For example, I have seen some social security numbers listed as much as 5 times with 4 of those being reacts and 1 being new. I figure there is some sort of measure to be made to figure this out. All help is greatly appreciated. 

[parry2k]

@alexstock01 it will be easier if you create some dummy data with the expected output.  Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490