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)