效果

图例带总计 x轴为creat_time y轴为度量值

DimChannelTotal = UNION ( VALUES ( DimChannel[showName] ); ROW ( "总计"; "总计" ) )

_最近N天业务量_withTotal = 
VAR T = [周期 值]
 VAR S = [业务 值] //次数1or值2
VAR T0 = TODAY()
VAR _CurrentAxis = SELECTEDVALUE('DimChannelTotal'[showName])
RETURN

IF(_CurrentAxis = "总计",
    IF(SELECTEDVALUE('总计'[业务值],1) = 1,
        IF( S = 2,CALCULATE(AVERAGE('业务'[total_vcode_sum]),FILTER('业务','业务'[create_time] <= T0 &&'业务'[create_time]>= T0 - T)),CALCULATE(AVERAGE('业务'[biz_code_count]),FILTER('业务','业务'[create_time] <= T0 &&'业务'[create_time]>= T0 - T))),
        BLANK()
    ),
    IF( S = 2, CALCULATE(sum('业务'[vcode_sum]),
        FILTER('业务','业务'[create_time] <= T0 &&'业务'[create_time]>= T0 - T),
        '业务'[showName] = _CurrentAxis
    ),
  CALCULATE(sum('业务'[event_code_count]),
        FILTER('业务','业务'[create_time] <= T0 &&'业务'[create_time]>= T0 - T),
        '业务'[showName] = _CurrentAxis
    ))
)

www.maxwikstrom.se/powerbi/how… 感谢大佬的博客

希望能启迪有缘人。

在powerBI中如何给折线图添加总计选项

效果