USERELATIONSHIP激活关系筛选图形

2021-02-08 本文已影响0人 BI罗

度量值做筛选激活

度量值 = 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]))