Forum Discussion

Larry130's avatar
Larry130
Frequent Visitor
9 years ago

Fixed Rank

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!

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee

    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