Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good Evening
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
Solved! Go to Solution.
Hi @ianboothman84 ,
You could use the following measure:
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 )
RETURN
IF (
MAX(table1[rank desc])< Percentile25,
"Q1",
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!
Best Regards
Lucien
Hi @ianboothman84 ,
You could use the following measure:
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 )
RETURN
IF (
MAX(table1[rank desc])< Percentile25,
"Q1",
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!
Best Regards
Lucien
@ianboothman84 , Check if this can help
https://sqldusty.com/2018/08/31/calculating-quartiles-with-dax-and-power-bi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |