Forum Discussion

Kerk's avatar
Kerk
Frequent Visitor
4 years ago
Solved

Conditional formatting by row issue

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

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Kerk
      Frequent Visitor
      4 years ago

      Thank you for looking in to this  Anonymous!