Forum Discussion
Stratifying into 1/3rds Formula
I have around 50 companies and their revenue amounts. I want to create a column or a measure (not sure which would be best) to stratify the revenue amounts into 1/3rds by largest to smallest in reven...
Greg_Deckler
Community Champion
Community ChampionSample data would be great. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Probably use RANKX to get a ranking and then you can segment that into thirds. Diffifult to be more specific.
Below is some sample data. So the file is two columns (Business and Revenue).
| Business | Revenue |
| Cubs | 344,748 |
| White Sox | 193,262 |
| Red Sox | 49,997 |
| Padres | 45,929 |
| Yankees | 155,912 |
| Dodgers | 82,667 |
| Mets | 79,192 |
| Cardinals | 77,123 |
| Braves | 74,897 |
| Astros | 80,239 |