Calculo de Cuartiles

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.