Forum Discussion

tps136's avatar
tps136
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Matrix multiple Sort columns

Hi All,   I've gone thru all other request in Desktop - Matrix Multiple column sort. But nothing  worked. Need experts help :smileyhappy: I am trying to sort 2 columns (1st level - Employee by ASC...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    tps136,

     

    You may try using ISONORAFTER Function to add a measure.

    Measure =
VAR e =
    SELECTEDVALUE ( Table1[Employee] )
VAR c = [TotalCount]
VAR t =
    SUMMARIZE ( ALLSELECTED ( Table1 ), Table1[Employee], Table1[Customer] )
RETURN
    COUNTROWS (
        FILTER ( t, ISONORAFTER ( Table1[Employee], e, DESC, [TotalCount], c, ASC ) )
    )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

tps136,

 

You may try using ISONORAFTER Function to add a measure.

Measure =
VAR e =
    SELECTEDVALUE ( Table1[Employee] )
VAR c = [TotalCount]
VAR t =
    SUMMARIZE ( ALLSELECTED ( Table1 ), Table1[Employee], Table1[Customer] )
RETURN
    COUNTROWS (
        FILTER ( t, ISONORAFTER ( Table1[Employee], e, DESC, [TotalCount], c, ASC ) )
    )
  • dsaladi's avatar
    dsaladi
    Regular Visitor
    7 years ago

    Hello,

     

    Can you provide me a .pbix file? I really appreciate it. Thanks.

  • twagnerSME's avatar
    twagnerSME
    Regular Visitor
    1 year ago

    I have another solution.

    Until the control is fixed to allow for multiple sorting patterns I would suggest the following.

    Create a column with the fields you want sorted in the order you want sorted.

     

    So in my example my matrix is grouped by Unit.  But I want my sort to be Unit and Days till launch.

    So creating a column as so

    SortColumn = Data[Unit] & ":" & Data[DaysTillLaunch]

    But in my case Unit is a text and [DaysTillLaunch] is an integer, (Cannot convert value error)

    so I have to convert the [DaysTillLaunch] to a text by using the Format to give me leading zeros. 

    SortColumn = Data[Unit] & ":" & FORMAT(Data[DaysTillLaunch],"000000")

    Then I add the sort column to values and sort ascending.

    It's clumsy but it works.