Forum Discussion

mg-66's avatar
mg-66
Regular Visitor
4 years ago
Solved

Calculate Average from highest X values

Hello everyone, I am new to Power BI and could need your help.   I have a Dataset that consistes of many tables and looks now like this: Date Temp. ..... ..... 105,2 ..... ..... 103...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    mg-66 , Create a column Rank

     

    R1= Rankx(Table, [Temp],,desc, dense)

     

    Then create a measure

     

    Averagex(filter(Table, Table[R1]<=2), Table[Temp])

amitchandak's avatar
amitchandak
Super User
4 years ago

mg-66 , Create a column Rank

 

R1= Rankx(Table, [Temp],,desc, dense)

 

Then create a measure

 

Averagex(filter(Table, Table[R1]<=2), Table[Temp])

mg-66's avatar
mg-66
Regular Visitor
4 years ago

amitchandak thank you for your Answer again. But this approach is not working. I also can not tell why or whats mistake I'm doing maybe.