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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
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.