How to highlight the least and highest value in a matrix columnwise?

[Anonymous]

In a matrix visual how to achieve highlighting of the low and high vaues, each column wise?

I have this measure,

MinMax =

VAR Vals =

CALCULATETABLE(

ADDCOLUMNS (

SUMMARIZE ( Sheet1, Sheet1[Portal Error Reason],Sheet1[MonthRanking] ),

"@SalesAmt", [Portal Error]

),

ALLSELECTED ()

)

VAR MinValue = MINX ( Vals, [@SalesAmt] )

VAR MaxValue = MAXX ( Vals, [@SalesAmt] )

VAR CurrentValue = [Portal Error]

VAR Result =

SWITCH (

TRUE,

CurrentValue = MinValue, 1, -- 1 for MIN

CurrentValue = MaxValue, 2 -- 2 for MAX

)

RETURN

Result

This measure is being added as a condition for coloring (conditional format by rule if 1 - yellow, 2 - Rose), this one highlights the overall highest value but what I want is to be able to highlight columnwise for both low and high values

How to modify this?

The visual uses a measure, for the counts.

Thanks

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

Switch( true() ,
[Portal Error] = calculate(Minx(values(Sheet1[Portal Error Reason]),[Portal Error]), removefilters(Sheet1[Portal Error Reason])) ,1

[Portal Error] = calculate(Maxx(values(Sheet1[Portal Error Reason]),[Portal Error]), removefilters(Sheet1[Portal Error Reason])),2
)

[Anonymous]

Thanks a lot, @amitchandak