List of Minimum Averages

[Anonymous]

I am using the formula below to show the historical record (minimum) average loading time by week over the course date range.

I want to create a Top 10 list of the record averages however, the formula I am using will only show the top record. Any ideas of how I can list the data out? 

MinAvg=

MINX(SUMMARIZE(ALL('Orders'),'CALENDAR'[WK_END_DATE],"Avg Amount",AVERAGE('Orders'[Loading])),[Avg Amount])

[selimovd · Accepted solution]

Hey @Anonymous ,

you can use the TOPN function to get the lowest average values.

Just group by your measure and sort ascending.

Check the short article how to do that:

TOPN – first N rows from table (DAX – Power Pivot, Power BI) – ExcelTown – kurzy přesně pro Vás

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Yes, this worked thank you for the link!