Based on the slicer, calculate rank on the fly and then summarise the data for rank= 1

[Anonymous]

Hi team,

I have already calculated rank on the fly, unfortunately, I couldn’t able to find the average of the data for rank =1

I wanted to group by section and find average of value for rank =1

please seee attached screenshot with highlighted : 

For the chosen participant from the slicer the average should be 7 instead of 6.

But I am getting average as 6..

 I would really appreciate if you could help me on this..

I have used this measure:

Average Value =
CALCULATE (
    AVERAGE ( Query2[Value] ),
    FILTER ( VALUES ( Query2[Participant] ), [Rank] = 1 )
)

Thanks 

[v-qiuyu-msft]

Hi @Anonymous,

Not sure if the Rank is a column or a measure. You can try measure below: 

Avg = CALCULATE(AVERAGE(Table2[Value]),FILTER(ALLSELECTED('Table2'),'Table2'[Rank]=1))

Best Regards,
Qiuyun Yu