Power BI 多列排序问题

新增计算列，录入需要排序的字段

Index =

VAR p = [Power Level]

VAR n = [Name]

VAR a = [Age]

VAR t1 = 'Table3'

VAR t2 =

    FILTER ( 'Table3', 'Table3'[Power Level] = p )

VAR t3 =

    FILTER ( 'Table3', 'Table3'[Power Level] = p && 'Table3'[Age] = a )

RETURN

    RANKX (

        t1,

        RANKX ( t1, [Power Level],, ASC, SKIP ) * 100

            + RANKX ( t2, [Age],, ASC, SKIP ) * 10

            + RANKX ( t3, [Name],, ASC, SKIP ),

        ,

        DESC,

        SKIP

    )