Calculo de Cuartiles

[Anonymous]

Buen dia

Quisiera saber si alguien conoce como hacer el calculo para sacar el rango de cada cuartil dentro de un grupo de datos 

Quedo atenta a sus comentarios

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, I have creaetd a simple example:

Please  try:

Q1 = 
var _a = COUNT('Table'[Number])
var _b = _a*0.25
var _c = CALCULATE(MAX('Table'[Number]),FILTER('Table',RANKX('Table',[Number],,ASC)=_b))
var _d = CALCULATE(MAX('Table'[Number]),FILTER('Table',RANKX('Table',[Number],,ASC)=1))
return "Q1: "&_d&"-"&_c

Q2 = 
var _a = COUNT('Table'[Number])
var _b = _a*0.25
var _c = CALCULATE(MAX('Table'[Number]),FILTER('Table',RANKX('Table',[Number],,ASC)=_b*2))
var _d = CALCULATE(MAX('Table'[Number]),FILTER('Table',RANKX('Table',[Number],,ASC)=_b+1))
return "Q2: "&_d&"-"&_c

Q3 = 
var _a = COUNT('Table'[Number])
var _b = _a*0.25
var _c = CALCULATE(MAX('Table'[Number]),FILTER('Table',RANKX('Table',[Number],,ASC)=_b*3))
var _d = CALCULATE(MAX('Table'[Number]),FILTER('Table',RANKX('Table',[Number],,ASC)=_b*2+1))
return "Q3: "&_d&"-"&_c

Q4 = 
var _a = COUNT('Table'[Number])
var _b = _a*0.25
var _c = CALCULATE(MAX('Table'[Number]),FILTER('Table',RANKX('Table',[Number],,ASC)=_b*4))
var _d = CALCULATE(MAX('Table'[Number]),FILTER('Table',RANKX('Table',[Number],,ASC)=_b*3+1))
return "Q4: "&_d&"-"&_c

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.