I have this table:
I would like to see something like
DE013 - - - - 1
DE013 - - - - 2
DE013 - - - - 3
DE013 - - - - 4
DE018 - - - - 1
DE018 - - - - 2
DE018 - - - - 3
but my rank doesnt work:
Company_code and Category are in two diferent tables.
Go to Solution.
@tsynenkyy This measure shoudl work for you:
Rank Entity =
VAR __CO = SELECTEDVALUE(Table1[Company_code])
RANKX( FILTER( SUMMARIZE(all(Table1),Table1[Company_code],Table2[Category]) , Table1[Company_code] =__CO) ,[Spend] )
⭕ Subscribe and learn Power BI from these videos ⚪ Website ⚪ LinkedIn ⚪ PBI User Group
View solution in original post
Hi, now I got this:
but the ranking is doing strange things, you can see a 2-3-2, how can I solve that?
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.