topic Re: How to get the Bottom funded Group by using TOPN? in DAX Commands and Tips

How to get the Bottom funded Group by using TOPN?

Omarion84 — Fri, 21 Jul 2023 16:05:21 GMT

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??

Re: How to get the Bottom funded Group by using TOPN?

AnthonyGenovese — Fri, 21 Jul 2023 17:50:57 GMT

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!

Re: How to get the Bottom funded Group by using TOPN?

Omarion84 — Sat, 22 Jul 2023 02:28:59 GMT

did not work... same result.