How to get the Bottom N, I was able to get Top N

[Omarion84]

I need to showcare the TOP Funded and the Lowest Funded Agency (in Cards)

I was able to show TOP,  in 2 different ways, but how do I change the formula to give me the bottom#? I tried to use ASC instead of DESC, the Agency returned is not the bottom one.

Top Funded 1 = Calculate( SELECTEDVALUE('Unique Data Per Order'[Agency]),FILTER(TopN(1, All('Unique Data Per Order'), [Total Funded Amount],DESC), TRUE))

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

[Mkarwa-123]

@Omarion84 to get bottom N make DESC to ASC in topN formula

Top Funded 1 = Calculate( SELECTEDVALUE('Unique Data Per Order'[Agency]),FILTER(TopN(1, All('Unique Data Per Order'), [Total Funded Amount],ASC), TRUE))

Did I answer your question? Mark my post as a solution!

[Omarion84]

As I mentioned in my post, I tried that, it did not bring the bottom *lowest funded agency*