Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I would like to display the ranking of a score (distance Kerstin to first place) over all competitors for a project and then rank them based on the value considering the date.
I have made a few attempts. None of them with success.
sample pbix: https://1drv.ms/u/s!AsLM3f2rQCP34xz66vVhqHp5pDA5?e=udXGuN
I think the problem is that I calculate the measured value or the sum_No_1 over all projects, but not for the defined date range.
In principle, I would like to have a ranking only over the projects in the selected time window. Nov22: 1-27
Accordingly, only these projects would be shown in the matrix.
Any tips on what is wrong?
Thanks
Chris
I would like to display the ranking of a score (distance Kerstin to first place) over all competitors for a project and then rank them based on the value considering the date
No idea what you mean by that. Can you show an example of the expected outcome?
Why is the Competition field hard coded with a rank?
At first I would like to achieve a ranking over the narrowed date range. There are 27 projects in the November 2022 time period: Ranking 1-27.
Based on this, I would like the matrix to show me only the projects with values 1 and 2.
However, if I set the filter to the visual, I get an empty matrix. It seems that the filter context does not take into account the narrowed date range and so, for example, the project with rank 1 for November 2022 gets rank 35 for the entire period.
Thanks
Chris
I think you will want to read this article.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |