Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a date field that I use to filter, when I use a date filter along with the name field it gives problem.
That way it works, because I'm selecting all the dates, but when I select 2018 only.
When I select with Kevin, the correct ranking does not appear.
I tried putting a filtering on calculate with the dates, it still did not work, would you have any tips?
I am using this data:
Name | Value | Date |
Roberto | 90 | 20/05/2018 |
Maria | 30 | 05/05/2018 |
Fatima | 25 | 05/04/2018 |
Marcos | 70 | 05/05/2018 |
Priscila | 120 | 05/03/2018 |
Nicole | 10 | 06/04/2018 |
Marcio | 70 | 07/05/2018 |
Kevin | 20 | 08/05/2018 |
Marta | 20 | 09/02/2018 |
Fernando | 90 | 10/05/2018 |
Roberto | 90 | 20/05/2017 |
Maria | 30 | 05/05/2017 |
Fatima | 25 | 05/04/2017 |
Marcos | 70 | 05/05/2017 |
Priscila | 120 | 05/03/2017 |
Nicole | 10 | 06/04/2017 |
Marcio | 70 | 07/05/2017 |
Kevin | 20 | 08/05/2017 |
Marta | 20 | 09/02/2017 |
Fernando | 90 | 10/05/2017 |
Hi @rmolinajr,
Try the measure:
Measure Rank By =
RANKX(
ALL(Example),
CALCULATE(
SUM(Example[Value])
),,DESC,Dense
)
If it solves your problem please mark as solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |