Forum Discussion

anandav's avatar
anandav
Skilled Sharer
7 years ago
Solved

Sorting by multiple columns

Hi Experts,   I have the following data.   Employee Training Date Greg Training 1 19/09/2017 Bill Training 1 19/09/2017 Joe Training 1 19/09/2017 David Training 1 19/09/2017 ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    anandav,

     

    You may try using ISONORAFTER Function to add a measure.

    Measure =
VAR t =
    SUMMARIZE (
        ALLSELECTED ( Table1 ),
        Table1[Employee],
        Table1[Training],
        Table1[Date]
    )
RETURN
    COUNTROWS (
        FILTER (
            t,
            ISONORAFTER (
                    Table1[Employee], SELECTEDVALUE ( Table1[Employee] ), DESC,
                    Table1[Training], SELECTEDVALUE ( Table1[Training] ), ASC,
                    Table1[Date], SELECTEDVALUE ( Table1[Date] ), DESC
            )
        )
    )
Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-chuncz-msft I created the measure you created previously in the thread and when I tried to place it as a value in the table field, it created a single count. Is there somewhere else I should be placing this measure? Thanks so much!