I need realize a RANKX for all years (2020-2022) and a RANKX only for a selected year. I have two tables: fatVendas and dCalendario. I create a measure Total das Vendas = SUM(fatVendas[Total da Venda]). Create too a calculated table with:Ranking por Mês/Ano = ADDCOLUMNS( DISTINCT(dCalendario[Mês/Ano]), "Receita Total", [Total das Vendas], "Rank Geral", RANKX(ALLSELECTED(dCalendario[Mês/Ano]), [Total das Vendas]))And I have this: And sounds good! But, I need calculate a rank in the year, when a user select a one year, show a rank in a year. How to realize this?

Hi, You may download my PBI file from here. Hope this helps.

Problem with RANKX | Microsoft Fabric Community

Ashish_Mathur
Super User
3 years ago
Hi,

Share the download link of the PBI file and show the expected result.
- fabiojoa
  Helper I
  3 years ago
  Ok!
  
  Here the PBI file: https://www.dropbox.com/t/ZZLrctX6bk6j4YMb
  
  Thanks!
  - Ashish_Mathur
    Super User
    3 years ago
    Hi,
    
    You may download my PBI file from here.
    
    Hope this helps.
Padycosmos
Solution Sage
3 years ago
Hope this video helps:
https://www.youtube.com/watch?v=inJ3Yt7ay30
fabiojoa
Helper I
3 years ago
Thank you, but this video does not answer my problem. What happens is that I need the general ranking, where each month was over the three years, and a second ranking to know the position of the month within the year selected by the user.
Padycosmos
Solution Sage
3 years ago
You may please try the following:
Rank = RANKX(ALLSELECTED([Ano]), [Total das Vendas],,DESC,DENSE)

If you are using a Matrix visual, this vdeo can help:
https://www.youtube.com/watch?v=y2FFjfRD-Bo
- fabiojoa
  Helper I
  3 years ago
  I try, but not working, all values are 1.