TopN Dax doesnt seem to be working

Hi everyone,

Attached is my report that I am building at the moment. We are a charity so this is our fundraising pipeline and I am interested to track our top 5 funders per year. Based on Sam’s demo data, I have used the Top Customer dax to show my data as they could be seen as customers in our financial data. However, I am struggling at the moment to get the Dax to pull the right information. It seems as if the dax is pulling the whole information as opposed to top 5. I have checked the relationship but cant seem to find an issue with it. Any help would be appreciated.

Attached is the file for your reference.


Fundraising Dashboard.pbix (228.0 KB)

Can you please add more information around your request to the forum post, not just add a pbix file.

See here for more info on best practices for asking questions on the forum.