topic Re: Ranking com duas colunas in DAX Commands and Tips

Ranking com duas colunas

Angelo-Silva — Thu, 09 Feb 2023 23:51:09 GMT

Ola Especialistas,
Gostaria de criar um ranking com base em duas colunas, conforme imagem(Produto e Fornecedor), onde o contexto de produto será respeitado e também o fornecedor

Re: Ranking com duas colunas

FreemanZ — Fri, 10 Feb 2023 01:41:32 GMT

hi Angelo-Silva

try like:

Ranking = RANKX( FILTER( TableName, TableName[Products] = EARLIER(TableName[Products]) ), TableName[Valor] )

Re: Ranking com duas colunas

Anonymous — Fri, 10 Feb 2023 02:00:14 GMT

Hi Angelo-Silva

1.You can create a measure

Measure = RANKX(FILTER(ALLSELECTED('Table'),'Table'[Product]=MAX('Table'[Product])),CALCULATE(SUM('Table'[Valor])),,DESC,Dense)

2.You can create a calculated column

Column = RANKX(FILTER('Table',[Product]=EARLIER([Product])),[Fornecedor],,DESC,Skip)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Ranking com duas colunas

Angelo-Silva — Fri, 10 Feb 2023 12:28:21 GMT

Obrigado, funcionou.

Re: Ranking com duas colunas

rob7one — Mon, 13 Feb 2023 15:33:37 GMT

Hola 🙂

I try to describe my case a bit:

I would like to rank an amount of defects within 3 columns: month, plant and vendor column. Is that possible too by creating a custom column?