Thank you for your time.
I currenty have a table built in power BI and i have ranked 3 areas of sales performance. At the end of the table i have created a total score then ranked the total (If that nakes sense)
Now i am struggling to create a quintile measure, please help 🙂
The Rank and Rank Desc are all measures
Go to Solution.
Hi @ianboothman84 ，
You could use the following measure:
VAR _table =
SUMMARIZE ( ALL (table1), Table1[His_UserfullName], "_Rank", MAX(table1[rank desc]))
VAR Percentile25 =
PERCENTILEX.EXC ( _table, [_Rank], 0.25 )
VAR Percentile50 =
PERCENTILEX.EXC ( _table, [_Rank], 0.5 )
VAR Percentile75 =
PERCENTILEX.EXC ( _table, [_Rank], 0.75 )
MAX(table1[rank desc])< Percentile25,
IF ( MAX(table1[rank desc])< Percentile50, "Q2", IF ( MAX(table1[rank desc])< Percentile75, "Q3", "Q4" ) )
Then you will get the below:
Wish it is helpful for you!
View solution in original post
@v-luwang-msft thnak you, works great 🙂
@ianboothman84 , Check if this can help
Proud to be a Super User!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.