度量值做筛选激活
度量值 = CALCULATE(SUM('Fact2'[X]),USERELATIONSHIP('dis'[ID],Fact2[ID]))
度量值 2 = VAR x=[度量值]
RETURN IF(NOT(ISBLANK(x)),1,0)
原本包含度量值的激活
度量值 = CALCULATE(SUM('Sheet1'[sell]),USERELATIONSHIP('city'[city],'Sheet1'[city]))
度量值 = CALCULATE(SUM('Fact2'[X]),USERELATIONSHIP('dis'[ID],Fact2[ID]))
度量值 2 = VAR x=[度量值]
RETURN IF(NOT(ISBLANK(x)),1,0)
度量值 = CALCULATE(SUM('Sheet1'[sell]),USERELATIONSHIP('city'[city],'Sheet1'[city]))
本文标题：USERELATIONSHIP激活关系筛选图形
本文链接：https://www.haomeiwen.com/subject/aijxxltx.html
网友评论