Some problems in Power BI look simple… until you try to solve them.

Recently, I was working on a dashboard where I needed something very specific: 👉 Identify the 2nd highest Salesperson based on Total Finance.

Sounds easy, right? Until you realize that DAX doesn’t have a direct “give me the 2nd top row” function — you’ve got to build the logic yourself.

So I went deeper into: 🔹 Filtering the entire Sales table 🔹 Excluding the top performer 🔹 Using TOPN inside another TOPN 🔹 Returning only the next highest Salesperson 🔹 Ensuring it works across all filters & contexts

The final DAX expression became a small story of its own — a reminder that data work is not just formulas, it’s problem-solving, iteration, and clarity in logic.