How to group single instance data values to then place in defined bins?

[Anonymous]

https://www.mssqltips.com/sqlservertip/4076/create-bell-curve-and-histogram-with-power-bi-desktop-us...

I'm attempting to create ranks with this tutorial - the only problem is my data isn't grouped yet as in the example. 

The example is like

         Category 1         Category 2           Percentage Rate

A            10                        100                         10%     

B

C

With my data I am trying to apply this concept to is like this

        Category 1         Category 2           Percentage Rate       

A              1                        1                              (blank all the way down because the % calc is based on a grouping not on                                                                                       individual level - because would result in 100% every time)

A              1                        1                               

A              1                        1

A              1                        1

What is the best way to group and summarize my data without a lot of hassle to create bins such as in the tutorial? 

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may use GROUPBY Function to create a calculated table.