新建度量值：

AMT = SUM( Sheet1[金额])

最小值 = IF([AMT]=

       MINX(ALLSELECTED(Sheet1[月份]),[AMT]),

    [AMT])

最大值 = IF([AMT]=

       MAXX(ALLSELECTED(Sheet1[月份]),[AMT]),

    [AMT])

MaxMinColor =

VAR amt =sum(Sheet1[金额])

VAR month_ =

ALLSELECTED(Sheet1[月份])

VAR Maxamt =

MAXX( month_, amt )

VAR Minamt =

MINX( month_, amt )

VAR Result =

SWITCH(

TRUE(),

amt=Maxamt, "Green",

amt=Minamt, "Red",

"blue"

)

RETURN

Result

出来的结果