Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Below measure works when only one row in the matrix table.
When I add a second row to the table, all the rankings change to 1.
Don't know what to try.
Hi @Qotsa ,
I did the following test and added the fields of the hierarchy to the matrix, and it didn't make an impression on the ranking.
So What is the calculation logic of the created [Last 8 by Con]? It is also possible that the Loaction field in the added hierarchy has an impact on the filter conditions. Can you provide a detailed data model (delete sensitive information) so that I can solve it for you as soon as possible.
Rank CHO3 = RANKX(ALL('Table'[Name]),[Measure],,ASC)
Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Qotsa , if you add any other grouped column in visual, the rank will happen inside that
Now Rank will happen inside the location for Group CHO3.
Try like
Rank CHO3 = RANKX(ALL('Query1'[Group CHO3],[location]),[Last 8 by Con])
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |