Forum Discussion
Quartile Analysis
Hi
I want to calculate Quartiles for PRR and RAP Performance Across two sites and for last three months. The Quartiles That I am receiving is not correct the distribution is not matching when I did it in excel.
This is the dax command I am using:
RR_Quartiles =
var high = PERCENTILEX.INC(
FILTER('Dax Groupby',ISBLANK(('Dax Groupby'[PRR%])) = FALSE()),
('Dax Groupby'[PRR%]),.75)
var mid = PERCENTILEX.INC(
FILTER(
'Dax Groupby',
ISBLANK(('Dax Groupby'[PRR%])) = FALSE()
),
('Dax Groupby'[PRR%]),.5)
var low = PERCENTILEX.INC(
FILTER(
'Dax Groupby',
ISBLANK(('Dax Groupby'[PRR%])) = FALSE()
),
('Dax Groupby'[PRR%]),.25)
return
IF(('Dax Groupby'[PRR%]) <= low, "Q4", IF(('Dax Groupby'[PRR%]) <= mid, "Q3", IF(('Dax Groupby'[PRR%]) < high, "Q2", "Q1")))