您可以Type2
通过与上一年进行比较来进行更改:
Change in Type2 =
VAR CurrType2 = SELECTEDVALUE ( Table1[Type2] )
VAR CurrYear = SELECTEDVALUE ( Table1[Year] )
VAR PrevType2 =
CALCULATE (
SELECTEDVALUE ( Table1[Type2] ),
ALL ( Table1[Type2] ),
Table1[Year] = CurrYear - 1
)
RETURN
IF ( ISBLANK ( PrevType2 ), BLANK(), IF ( CurrType2 = PrevType2, 0, 1 ) )
更改的总和非常简单:
Change Sum = SUMX ( VALUES ( Table1[Type1] ), [Change in Type2] )
非常感谢您抽出宝贵的时间。效果很好!