Problem with RANKX

[fabiojoa]

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?

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the expected result.

[fabiojoa]

Ok!

Here the PBI file: https://www.dropbox.com/t/ZZLrctX6bk6j4YMb

Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[fabiojoa]

Ashish, thanks!!!

What the problem in using a Month/Year or Month/Year and Year columns in table?

[Ashish_Mathur]

You are welcome.  Should not be.  Since year is already selected in the slicer, showing it in the Table is superfluous.

[Padycosmos]

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]

I try, but not working, all values are 1.

[fabiojoa]

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]

Hope this video helps:

https://www.youtube.com/watch?v=inJ3Yt7ay30