RANKX incorrect after adding row to matrix

[Qotsa]

Hi,

Below measure works when only one row in the matrix table.

Rank CHO3 = RANKX(ALL('Query1'[Group CHO3]),[Last 8 by Con])

When I add a second row to the table, all the rankings change to 1.

 Don't know what to try.

[v-henryk-mstf]

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.

[amitchandak]

@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])

[Qotsa]

@amitchandak 

Thanks. It's not quite right. The rankings are a bit off.