Run a MAXX over the RANKX and then subtract the rank from the result. That makes the BottomN behave like the TopN.
Watch out for performance issues with large lists.
I'll keep that in mind. For the moment I have duplicated the table and added a top n and bootom n. This way they can compare the top and the bottom at a glance.
Thanks for your reply
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.