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