Forum Discussion
Formula Help
I have used a RANKX formula on a column named Clothes and now I want the top third of the data to get assigned a value of 15, the middle third of the data to be assigned 10, and the bottom third to b...
Perhaps:
Column = VAR __break = MAX([Rank])/3 RETURN SWITCH(TRUE(), [Rank] <= __break,15, [Rank] > 2*__break,5, 10 )
parry2k
Super User
Super UserAnonymous can you post what your expected output should be. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I added another column in the table which is labed Risk Score. This data is just a very small and simple sample data to what I am actually using. As you can see in the Risk Score column, the top 3 got a Risk Score of 15, the middle 3 got a score of a 10, and the bottom three got a score of 5. I want me full data to have formula where it can stratify the data into thirds and assign it the proper risk score.
Clothes Rank Risk Score Pants 4 10 Hat 7 5 Shirts 9 5 Shorts 2 15 Dress 5 10 Skirts 8 5 Socks 6 10 Jacket 1 15 Shoes 3 15