How to get the Bottom funded Group by using TOPN?

[Omarion84]

I have this measure that works fine on a card visual, displaying TOP funded group name, yet I need also to display the least funded group to get the Bottom funded group name.

Top Funded Group= FIRSTNONBLANK(Topn(1,values('Unique Data Per Order'[Group]),[Total Funded]),1)

Does anyone know how??

[AnthonyGenovese]

You just need to apply the order filter (Change the second 1 to a 0)

Bottom Funded Group= FIRSTNONBLANK(Topn(1,values('Unique Data Per Order'[Group]),[Total Funded]),0)

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

[Omarion84]

did not work... same result.