Forum Discussion
Using Percenitles Based On Variable
I am trying to do a percentile calculation based on what customer segment(group) the customer are in. I have a column that corresponds to the customer and reflects what segment they are in. Here ...
Here is the sample data:
This reflects Customer ID, the Group the customer belongs to and the # of Orders. The F value in the dax formula I have is the # of Orders.
| Customer ID | Customer Group | # of Orders |
| 706104 | C | 3 |
| 994195 | C | 2 |
| 386615 | A | 1 |
| 235864 | A | 5 |
| 922887 | B | 9 |
| 567869 | C | 7 |
| 494345 | C | 9 |
| 606611 | C | 1 |
| 184412 | A | 0 |
| 357310 | A | 8 |
| 285382 | B | 1 |
| 547244 | C | 3 |
| 75757 | C | 5 |
| 935099 | C | 8 |
| 685859 | A | 8 |
| 741397 | A | 9 |
I want to rank the customer based on the group they belong to, and not the entire data set. We have many customer groups and I want to rank customers based on the group they belong to.
Here is a result sample
| Customer ID | Customer Group | # of Orders | Perecntile Rank |
| 706104 | C | 3 | 3 |
| 994195 | C | 2 | 1 |
| 567869 | C | 7 | 2 |
| 494345 | C | 9 | 5 |
| 606611 | C | 1 | 1 |
| 547244 | C | 3 | 2 |
| 75757 | C | 5 | 4 |
| 935099 | C | 8 | 5 |
Here is another result samples
| Customer ID | Customer Group | # of Orders | Perecntile Rank |
| 386615 | A | 1 | 1 |
| 235864 | A | 5 | 3 |
| 184412 | A | 3 | 2 |
| 357310 | A | 8 | 4 |
| 685859 | A | 8 | 4 |
| 741397 | A | 9 | 5 |