Ranking Project Items by Size

[Alta88]

How would I rank the following project IDs by these two categories? Small Projects and Large Projects. Project IDs with XXS - S are grouped into the Small category. Projects with M - XXXL are grouped into the Large category. I'm wondering how best to execute this in DAX...

ID	Project size
1	XXXL
3	L
6	S
8	M
25	L
57	XS
77	L
81
98
100
127	S
136	M
137	M
162	L
165	S
166	L
174	S
188	S
189	XS
190	L
191	M
193	XS
197	S
198	XS
200

[Alta88]

Thanks, Vicky! This works well! Follow up question: what if I wanted to display the top 3 for both of those categories (Large vs. Small)?

[vicky_ · Accepted solution]

You can use a calculated column :

Project Size Group = IF([Project size] in {"XXS","XS","S"}, "Small", "Large")

(note, this can be done in PowerQuery as well, although with a different formula; you can access the instructions here: https://support.microsoft.com/en-au/office/add-a-conditional-column-power-query-f2422ed1-f565-4e64-b...)