Forum Discussion

Chrisss14's avatar
Chrisss14
Frequent Visitor
3 years ago
Solved

Exclude Lowest and Highest Values

Hi All,   I'm trying to figure out the best way to exclude 5% of the top and bottom values in the table I currently have.    For example if I filter the Top 5 lowest numbers I may have 12,14,16,1...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Chrisss14 ,

     

    Based on your description, I have created a simple sample:

    Please try:

    Measure = 
var _a = COUNTROWS('Table')
return AVERAGEX(TOPN(0.9*_a,TOPN(0.95*_a,'Table',[Value],ASC),[Value],DESC),[Value])

    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 Chrisss14 ,

 

Based on your description, I have created a simple sample:

Please try:

Measure = 
var _a = COUNTROWS('Table')
return AVERAGEX(TOPN(0.9*_a,TOPN(0.95*_a,'Table',[Value],ASC),[Value],DESC),[Value])

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.