Some problems in Power BI look simple… until you try to solve them. Recently, I was working on a ...Some problems in Power BI look simple… until you try to solve them. Recently, I was working on a ...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Vikas's avatar
Vikas Kashyap
• Nov 17
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.
Data VisualizationData AnalysisMicrosoft Power BI
Post image
Post image
Post image
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started