DAX 函数 RANKX 中的 value 参数 [英] The value parameter in DAX function RANKX

问题描述

你能解释一下

我有左表的排名

Rank Switch = RANKX(ALLSELECTED('Switch'[Game]); CALCULATE(SUM('Switch'[Rating])))

一个用于右表:

Rank PC = RANKX(ALLSELECTED('PC'[Game]); CALCULATE(SUM(PC[Rating])))

这个排名独立于另一个表.但是左桌的排位和右桌的排位相比又如何呢?这是 value 参数开始使用的.

所以你看到右表的最高评分仅排在第二位，因为左表中的荒野之息.

Can you explain what is the job of the value parameter in function RANKX? I could not figure out from documentation what it is for:-)

RANKX(<table>, <expression>[, <value>[, <order>[, <ties>]]])  

Possibly, if you could submit an example how it works.

解决方案

Let´s say I have to tables. Withhin this tables I can rank the games by their rating. Like this:

I have a rank for the left table

Rank Switch = RANKX(ALLSELECTED('Switch'[Game]); CALCULATE(SUM('Switch'[Rating])))

and one for the right table:

Rank PC = RANKX(ALLSELECTED('PC'[Game]); CALCULATE(SUM(PC[Rating])))

This ranks are independent from the other table. But what about the raiting of the left table compared to the raiting of the right table? This is were the value parameter comes to use.

So you see the highest raitings on the right table are just on second place because of Breath of the Wild in the left table.

这篇关于DAX 函数 RANKX 中的 value 参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！