Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Share the download link of the PBI file and show the expected result.
Hi,
You may download my PBI file from here.
Hope this helps.
Ashish, thanks!!!
What the problem in using a Month/Year or Month/Year and Year columns in table?
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:
I try, but not working, all values are 1.
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.
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |