Forum Discussion
Rankx for a Hierarchy
Hi All,
I am having trouble getting my matrix to sort based on a selected value from the slicer. For example, if the selected value is "Base Salary" then I would like the base salary column to be sorted in DEC order and the same idea with the Tota Salary column. The drill-down of the matrix is [Job Title] -> [Name], I would like it to only sort the Job title
Thank you in advance!
5 Replies
- amitchandak
Super User
Anonymous , You can create two ranks measure or vars
Rank1 = RANKX(ALL(Table[Job Title]), [salary])
Rank2 = RANKX(ALL(Table[Name]), [salary])
Switch rank = Switch( True() ,
isinscope(Table[Name]) , [Rank2],
isinscope(Table[Job Title]) , [Rank1],
blank()
)
- amitchandak
Anonymous ,
Switch rank = Switch( True() ,
isinscope(Table[Name]) , [Rank2],
isinscope(Table[Job Title]) && not(isinscope(Table[Name]) ) , [Rank1],
blank()
)
