Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Average Top 5 Premiums

Hi,

How to calcualte Average Top 5 Premiums  from below table:

 

Premium
5000
4000
30000
2000
1000
500
200

 

Please help asap.

Need Help

1 Reply

  • Igna's avatar
    Igna
    Icon for Resolver III rankResolver III
    3 years ago

    Hello,


    You can try this DAX Formula :

     

    Average Top 5 Premiums =
AVERAGEX(
TOPN(5, 'TableName', [Premium], DESC),
'TableName'[Premium]
)

     

     

    Igna