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...
Anonymous
One way is percentile - https://community.powerbi.com/t5/Desktop/Calculating-the-percentile-for-a-set-of-data/td-p/250581
Second is the percent of running total,
Like
measure =
var _1 = divide(calculate(table[revenue],filter(all(table),table[revenue]<=table[revenue])),calculate(table[revenue],all(table)))
return
if(_1<=.33 ,15, if(_1< .66,10,5))