RANKX未给出正确的结果-Powe BI桌面

我需要创建一个度量(而不是列),根据值对用户进行排名。

这里我尝试使用RANKX函数:

ranking = 
RANKX(
    ADDCOLUMNS(
        SUMMARIZE(dim_User, 
            dim_User[UserID],
            dim_User[FirstName]
        ),
        "Ttl Trans", [Ttl Transactions]
)
, [Ttl Transactions]
)

rating2 = 
RANKX(
    SUMMARIZE(dim_User,
    dim_User[FirstName]
), [Ttl Transactions]
)

试着这样做:

rating1 = 
RANKX(
    SUMMARIZE(dim_User,
    dim_User[FirstName],
    "Trans",[Ttl Transactions]
), [Trans]
)

The value for 'Trans' cannot be determined. Either the column doesn't exist, or there is no current row for this column.

如果我使用一个表,而不是一个表表达式,它似乎是有效的。

更新: 添加 ALL(dim_User)

ranking = 
RANKX(
    ADDCOLUMNS(
        SUMMARIZE(ALL(dim_User), 
            dim_User[UserID],
            dim_User[FirstName]
        ),
        "Ttl Trans", [Ttl Transactions]
)
, [Ttl Transactions]
)

使现代化

无论我选择哪个用户,在 rating