How to highlight every new high max value

[DaxAssistance]

Hello Everyone,

I have a matrix table that I would like to highlight every new instance of a new max on each row.(Going from left to Right)

Please see below:

Table Name - Customer_Weight

Fields : Customer Name, Date, Weights

Matrix table example

                        Jan    Feb    Mar   April

Customer 1     4          2        8        1

Customer 2      5         8        2       10

Customer 3       6        5         4        3

I want the result of the conditional format to show the following highlighted red

                        Jan    Feb    Mar   April

Customer 1     4          2        8        1

Customer 2      5         8        2       10

Customer 3       6        5         4        3

Any help would be great 

thanks again !!!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Weight measure: = 
SUM( Customer_weight[Weights] )

Color condition measure: =
VAR _maxvalueuptocurrentmonth =
    CALCULATE (
        MAX ( Customer_weight[Weights] ),
        WINDOW (
            1,
            ABS,
            0,
            REL,
            ALL ( 'Calendar'[Year-Month sort], 'Calendar'[Year-Month] ),
            ORDERBY ( 'Calendar'[Year-Month sort], ASC )
        )
    )
RETURN
    IF ( [Weight measure:] = _maxvalueuptocurrentmonth, "Red" )

[DaxAssistance]

You're Amazing thank you so Much !!!!!