Forum Discussion
Solved
Creating a Rank for each Item By Custumer
Hi! tnx a lot for reading my post, My goal is to obtain the row TOP in powerr bi using rankx, This is a rank for each item by customer in the same table....
aquanr18 Please try this as a "New Column"
Top = RANKX(FILTER(Test58Rank,Test58Rank[Client]=EARLIER(Test58Rank[Client])),Test58Rank[Sales],Test58Rank[Sales],DESC)
I have try both, in the measure i got the previus error,
If I use a calculated the error is 'Function 'RANKX' dose not support comparing values of type text with values of type integer, consider using the value or format function to convert one of the values'
Here you can see the table I'm using
https://drive.google.com/open?id=1VNrH9QlZ6BKpP4NbC08qrmYJbVCi_o17
aquanr18 Please try this as a "New Column"
Top = RANKX(FILTER(Test58Rank,Test58Rank[Client]=EARLIER(Test58Rank[Client])),Test58Rank[Sales],Test58Rank[Sales],DESC)