I need return average the field "%confidence" of the third highest value in quantity

[eraldo_DP]

Hi, Community!

I need to return average the field "%confidence" of the third highest value in quantity, and create rank for each word. Can you help me?

Download sample database: https://1drv.ms/x/s!As-s3TNexQ8TiqMtKlDh9BJcLHIWBQ?e=EkGuDk

[stevedep]

3rd highest value? Can you explain?

[eraldo_DP]

Hi, Steve. I will make three cards available on the panel, each with the confidence average, the first card with TOP 1 another card with TOP 2 and another with TOP 3.  Also, i need to show a table only top 10, but solving the first case I will solve the latter.

[stevedep]

Hi,

The average of the top 3 confidences?

[eraldo_DP]

Yes, third biggest amount quantity word, but returning the average of the field "confidence".

averageapproximating the statistical norm or average or expected valueMore (Definitions, Synonyms, Translation)

[stevedep]

For starters, this is the dataset:

https://dax.do/JwLmA8yolRwUpV/ 

I loaded it into a power bi file and created this measure:

Top3Average = CALCULATE(AVERAGE('Table'[Confidence]),FILTER(ALL('Table'), [Total]<=3))

File is attached. I am really not sure if this is what you are looking for. Lets see..

Kind regards, 

Steve.