RANKX DAX - Columnas y Filas

Question

Hola,&nbsp;Necesito realizar un ranking, y no logro hacerlo.&nbsp;Tengo distintas columnas como medidas, es decir tengo una columna para Ventas 1, otra columna para Ventas 2 y otra para Ventas 3. Además tengo una columna que me indica las clasificaciones (A,B,C) para cada Venta, quedando algo así:&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp;CVenta 1&nbsp; &nbsp;10&nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp;90&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Venta 2&nbsp; &nbsp;40&nbsp; &nbsp; 80&nbsp; &nbsp; &nbsp; &nbsp;60Venta 3&nbsp; &nbsp;70&nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp;30Total&nbsp; &nbsp; &nbsp; 120&nbsp; 150&nbsp; &nbsp; &nbsp;180&nbsp;&nbsp;El ranking necesito realizarlo en base al total de cada clasificación. Quedando así el ranking:&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp;CVenta 1&nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Venta 2&nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp;2Venta 3&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp;3&nbsp;Muchas gracias!

v-yuta-msft · Accepted Answer

Hi&nbsp;Paula,
&nbsp;
To achieve your requirement, create a calculate column using DAX as below:
Rank = RANKX(FILTER(Table1, Table1[Category] = EARLIER(Table1[Category])), RANKX(ALL(Table1), Table1[Value]), , ASC, Dense)
&nbsp;
&nbsp;
You can also refer to PBIX file here: https://www.dropbox.com/s/xl0kr9grzl9gg9l/RANKX%20DAX%20-%20Columnas%20y%20Filas.pbix?dl=0.
&nbsp;
Best Regards,
Jimmy Tao

Forum Discussion

RANKX DAX - Columnas y Filas

2 Replies

Related content

RankX

Rankx ignorando 1 columna

RANKX

Advanced Ranking (Rankx)

Rank vs Rankx