各位大神,求帮助:
如何取排名前3名的层级的值?? ( 同时满足条件: 排名前3的第一类(FeederSetup[Operatorion Description]) 同时也是排名前3的第2类(FeederSetup[Verficiation Result])值和排名前3的第3类(FeederSetup[Device Status]值 )
A) TOP3 FeederSetupCount (%) = IF ( [FeederSetupCount RANKX]<=3, [FeederSetupCount (%)] )
用上面的公式取出前3名的值,同时也把第一类排名第4.5.6 的第二类和第3类的排名小于等于3也取出来了,结果不是期望的,如红色区域,求帮助???
PS. DAX 各臣级排名公式如下:
FeederSetupCount RANKX =
IF (
HASONEFILTER ( FeederSetup[Device Status] )
&& [FeederSetupCount (%)] > 0,
RANKX (
ALLSELECTED ( FeederSetup[Device Status] ),
[FeederSetupCount (%)],
,
DESC,
SKIP
),
IF (
HASONEFILTER ( FeederSetup[Verficiation Result] )
&& [FeederSetupCount (%)] > 0,
RANKX (
ALLSELECTED ( FeederSetup[Verficiation Result] ),
[FeederSetupCount (%)],
,
DESC,
SKIP
),
IF (
[FeederSetupCount (%)] > 0
&& HASONEFILTER ( FeederSetup[Operatorion Description] ),
RANKX (
ALLSELECTED ( FeederSetup[Operatorion Description] ),
[FeederSetupCount (%)],
,
DESC,
SKIP
)
)
)
)
网友评论