Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculo de Cuartiles

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
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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.