Power Pivot - Count IF and Ranking Help

Nothing I have found online seems to be working for that I am needing. I need to have a calculated column in Power Pivot that will count how many times a customer number appears in a column.

Once that count is done, I will have another column which ranks them based on cumulative number of occurences.

If I could get both formulas into 1 column, even better but if I need two columns that is fine.

I will use this data to create 10 charts, 1 each for each of the top 10 customers, which will change dynamically as the data is updated daily.

Any ideas?