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

问题描述

您能解释函数

我对左表

 等级切换= RANKX（ALLSELECTED（'Switch'[Game]）; CALCULATE（SUM（'Switch'[评级]））
  

，其中一个用于右表：

 排名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屋！