Conditional formatting by row issue

[Kerk]

Hi everyone,

In the "Qualification times" tab, I am using the "MinMax" measure in a matrix to format the min and max values of each row.

The min values seem to be working and are getting marked in green, but the max values do not work.

I am not able to figure out what have I done wrong.

Your help would be appreciated.   

Please find the pbix here: https://www.dropbox.com/s/zvd5q0zk45fbdme/SWM_TestDB.pbix?dl=0 

thank you in advance

[Anonymous · Accepted solution]

Hi @Kerk ,

Please try:

Measure 2 = 
var _T= SUMMARIZE(ALLSELECTED('Bookings'),[Styles.Style],Bookings[Distance(Distance).Distance],[Swimmer], "Time",[PB_Formated])
VAR MinValue = MINX(FILTER(_T,[Styles.Style]=MAX(Bookings[Styles.Style]) && [Distance(Distance).Distance]=MAX('Bookings'[Distance(Distance).Distance])),[Time])
VAR MaxValue = MAXX(FILTER(_T,[Styles.Style]=MAX(Bookings[Styles.Style]) && [Distance(Distance).Distance]=MAX('Bookings'[Distance(Distance).Distance])),[Time])
VAR CurrentValue = [PB_Formated]
VAR Result = 
    SWITCH ( 
        TRUE,
        CurrentValue = MinValue, 1, -- 1 for MIN
        CurrentValue = MaxValue, 2  -- 2 for MAX
    )
RETURN
    Result

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kerk]

Thank you for looking in to this  @Anonymous!