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:
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?
Solved! Go to Solution.
Share the download link of the PBI file and show the expected result.
You are welcome. Should not be. Since year is already selected in the slicer, showing it in the Table is superfluous.
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:
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.