视图层计算的威力-缩减2亿数据

test_line_ya_acc = 
var t11=ADDCOLUMNS(FILTER('Date','Date'[QTD_YA_Total_Flag_Sum(ty)]="Y"),
                    "date1",'Date'[Date],"ya1",CALCULATE([Basic.TY.Value]))

var t12=ADDCOLUMNS(FILTER('Date','Date'[QTD_YA_Total_Flag_Sum(ya)]="Y"),
                    "date1",'Date'[Date],"ya1",CALCULATE([Basic.YA.Value]))
var t1=UNION(t11,t12)
var t2 =ADDCOLUMNS(t1,"date2",IF(YEAR([date1])=2020,DATE(YEAR([date1])+1,MONTH([date1]),DAY([date1])),[date1]),"ya2",[ya1])
var mind=MINX(t2,[date2])
var maxd=MAXX(t2,[date2])
var xd=SELECTEDVALUE(Dim_date_test[Date])
var t3=
   FILTER(t2,[date2]>=mind&&[date2]<=xd)

return IF(maxd>=xd,SUMX(t3,[ya2]),BLANK())