Forum Discussion

fabiojoa's avatar
fabiojoa
Helper I
3 years ago
Solved

Problem with RANKX

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 Ven...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

    • fabiojoa's avatar
      fabiojoa
      Helper I
      3 years ago

      Ashish, thanks!!!

       

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

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

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