Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi   amitchandak! Thanks for your quick response,
I tried this just now, It is not working when I have the [Name] field as the second level to the heiarchy. Am I missing something?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous ,

 

Switch rank = Switch( True() ,

isinscope(Table[Name]) , [Rank2],

isinscope(Table[Job Title])  && not(isinscope(Table[Name]) ) , [Rank1],

blank()

)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Unfortunately, this is not working either...