Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi to all i have this list of names sorted by total and i want to make 3 groups big, medium, low. The first group (big) i want to have first 20% of the names the second(medium) the next 60% and third(low) the rest 20% of the names is this possible?
NAMES | Total |
name1 | 994 |
name2 | 144 |
name3 | 116 |
name4 | 78 |
name5 | 32 |
name6 | 12 |
name7 | 5 |
name8 | 3 |
name9 | 3 |
name10 | 2 |
name11 | 1 |
name12 | 1 |
name13 | 1 |
Is it possible to have three different numbers?
@skourtip Maybe try 2 columns:
Rank = RANKX('Table2',[Total],,ASC)
Category =
VAR __Max = MAX('Table2'[Rank])
VAR __Rank = [Rank]
VAR __Percent = DIVIDE(__Rank,__Max,0)
RETURN
SWITCH(TRUE(),
__Percent >= .8,"Big",
__Percent <= .2,"Low",
"Medium")
I think its super thank yoy Greg one more question, if i want to change the percentages? i see number only in big and low, how about medium?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |