Hi,
I've attached an example of my data and project of what im trying to do but for some reason i cant get it to work correctly. No doubt I'm probably doing this wrong so any help and advice would be much appreciated.
I'm trying to list the top 3 customers that have ordered the most (by revenue) to be displayed in a table but its not working the way I thought it would.
As you can see from the project I've created 2 calculated columns, one to calculate the total revenue from all the orders they've placed and another to rank the customers by most revenue using the below DAX:
Calculate total revenue from all orders by the same customer:
Rank Customer by most revenue from their orders:
When looking at the data the new columns are working as expected. But the issue i have is showing the data in a table, as you can see from the image below its showing rank 1, 2 and 4. How come its now showing the 3rd biggest customer and instead showing the 4th biggest?
powerbi-test.PNG
Also is there a simpler way to do what I'm after?
Any help and advice would be much appreciated and thank you.
Bookmarks