Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Max value by group

Hi there,   I have three table,   Group,Product,Sales And I want to creat a new measure to show the max value for sales by groupname. How to do this ? Please help me.   BRs Dor...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    thank you for your explanation, and please check the below picture and the attached pbix file.

    The new measure has to be written like below, and then you can select this measure as a "Field Value" inside the Conditional Formatting -> Background color option.

     

     

    Max sales value by groupname color format: = 
VAR maxsales =
    CALCULATE ( MAX ( Sales[Sales] ), ALLEXCEPT ( Sales, 'Group'[GroupName] ) )
RETURN
    IF ( SUM ( Sales[Sales] ) = maxsales, "Red" )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

It is for creating a new measure.

 

 

Max sales value by groupname: =
SUMX ( VALUES ( 'Group'[GroupName] ), CALCULATE ( MAX ( Sales[Sales] ) ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Jihwan_Kim ,

    Sorry I told not so clear,

    My final purpose is to do like this.

    The max turn background color in the same groupname.

    How to do this? Thanks a lot.

     

     

    BRs 

    Dora.

     

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      4 years ago

      Hi,

      thank you for your explanation, and please check the below picture and the attached pbix file.

      The new measure has to be written like below, and then you can select this measure as a "Field Value" inside the Conditional Formatting -> Background color option.

       

       

      Max sales value by groupname color format: = 
VAR maxsales =
    CALCULATE ( MAX ( Sales[Sales] ), ALLEXCEPT ( Sales, 'Group'[GroupName] ) )
RETURN
    IF ( SUM ( Sales[Sales] ) = maxsales, "Red" )
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Jihwan_Kim  Thanks a lot