Forum Discussion

erin_g's avatar
erin_g
Regular Visitor
6 years ago
Solved

Max Calculation

Hello Everyone, New to DAX here. I am trying to calculate the highest RandD Normalization Filtered Percent specifically by Division, taking into account all of the filters in the table. Any idea o...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi erin_g ,

     

    Create a measure and apply it to visual level filter.

    Measure = 
VAR MAX_PER_DIVISION = CALCULATE(MAX('Table'[Normalization RandD]),ALLEXCEPT('Table','Table'[Division]))
RETURN IF(MAX('Table'[Normalization RandD])=MAX_PER_DIVISION,1,0)

    Sample .pbix

     

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

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

erin_g 

Are you wanting this as a measure for showing in reports or a calculated column on the table?  I only ask because I see you have a [RandD Max] column in your sample.

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    As a measure just use

    MAX RandD Normalization Filtered measure = MAX ( Your_Table[RandD Normalization Filtered] )

    Then show that next to the divisions:

     

    As a calcualated column it would be something like this.

    Division MAX RandD Normalization Filtered = 
CALCULATE(
    MAX('Your_Table'[RandD Normalization Filtered]),ALLEXCEPT('Your_Table','Your_Table'[Division]))