Forum Discussion

AbbasG's avatar
AbbasG
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

Highlighting the max value (%) in a measure

Hello All, I have data of suppliers with their regular prices and MSRP. I have created a measure that calculates % difference on regular prices with MSRP as a base value. Now I want to highligh...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi AbbasG ,

     

    I modified my color measure. Please take a look.

    Color = 
VAR _rank =
    RANKX (
        FILTER (
            ALLSELECTED ( 'All suppliers Combined Data' ),
            [Model#] = MAX ( 'All suppliers Combined Data'[Model#] )
        ),
        [Min of MSRP % difference from Min of Price],
        ,
        DESC,
        DENSE
    )
RETURN
    IF ( _rank = 1, "Green", "White" )

     

     

    Best Regards,

    Stephen Tao

     

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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi AbbasG ,

 

I modified my color measure. Please take a look.

Color = 
VAR _rank =
    RANKX (
        FILTER (
            ALLSELECTED ( 'All suppliers Combined Data' ),
            [Model#] = MAX ( 'All suppliers Combined Data'[Model#] )
        ),
        [Min of MSRP % difference from Min of Price],
        ,
        DESC,
        DENSE
    )
RETURN
    IF ( _rank = 1, "Green", "White" )

 

 

Best Regards,

Stephen Tao

 

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

 

AbbasG's avatar
AbbasG
Icon for Memorable Member rankMemorable Member
4 years ago

Anonymous This helps. Thank you so much 🙂