Fixed Rank

[Larry130]

Hi!

When you have a table with alll employees names rank from 1 to 10, how do I add more columns in this visualization without affecting the rank built? I've used the DAX below. It work, but I need to add the "Department" just for information, without changing the rank based on all employees.

Fault = COUNT(Employee[Fault])

Rank = RANKX(ALL(Employee[Name]),[Fault])

Thanks!

[v-caliao-msft]

@Larry130,

Coudl you please add some screenshots about your report, and provide us some sample data, so that we can make further analysis.

We can fix the sort by using Sort feature.

Regards,

Charlie Liao