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.
Hello Experts,
I am having a table as below-
Site Year Result
A 2014 5
A 2015 6
B 2014 3
B 2015 7
C 2014 3
C 2015 2
D 2014 1
D 2015 4
I am trying to derive the overall and yearwise ranks for the sites based on results. I am getting the correct result for overall ranks, however when i try apply the year filter, the ranks shows the wrong value.
I am using below dax for the same-
Site Ranks = Rankx (ALL( Data[Site]), Calculate(Average(Data[Result]),ALLEXCEPT(Data,Data[Year],Data[Site])),,ASC,Skip.
Can you please help me to get the yearwise correct ranks for the same??
Solved! Go to Solution.
Hi @Anonymous ,
I tried to recreate the same model as you. It works for me when I filter by year (by adding the years to my table) and shows the ranking.
Can you explain more about your problem?
Regards,
LC
Hi @Anonymous ,
I tried to recreate the same model as you. It works for me when I filter by year (by adding the years to my table) and shows the ranking.
Can you explain more about your problem?
Regards,
LC
No problem!
Glad it helped,
LC
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |