How to calculate n top value of a measure

[Fariba1984]

Hi experts,

I have a claculated measure, which is strongly related to Date-Values. In a Time range, I would like to sort asc this measure and then calculate the average of n values of it.

n is: 

Quantile:=
var CalculateQuantil= ROUNDUP(DISTINCTCOUNT(Table1[Date_SID]) * 0,2;0)
return CalculateQuantil

 and then:

How can I do that in dax?

[hernandezguzman]

Hi, 

Are you trying to balancing the data in bin buckets or just try to get the averages, I need to create a balancing funcinality like quantile but I was not been able to do it, do you know if there are any functions in PBI,

thanks?

[Anonymous]

I think this thread will answer your question.@sturlaws,  give the DAX with the PBIX file that you can download.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/calculate-average-for-Top-3-5-10/td-p/904215

[amitchandak · Accepted solution]

@Fariba1984 , refer

Top 80/20 , percent /percentile
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/td-p/763156

[Fariba1984]

Thank you sir for yor post:

I am trying the following Dax:

Quantil:=
var CalculateQuantil= ROUNDUP(DISTINCTCOUNT(Table[Date_SID]) * 0,2;0)
return
CALCULATE([Measure1];
FILTER(VALUES(Table[Date_SID]);
 RANKX(VALUES(Table[Date_SID]);[Measure1];True()) <= CalculateQuantil))

 but I get this error:

Error: Calculation error in measure 'Table Analysis'[Quantil]: Function 'RANKX' does not support comparing values of type Number with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values. 

What is my mistake?

[Greg_Deckler]

@Fariba1984 This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.