Forum Discussion

gsamaral77's avatar
gsamaral77
Helper I
5 years ago
Solved

Return critical point

Hello, I hope everyone is alright   I have a data with the vibration measure of some machines, I want to create a table with the critical point of that machine     I created the measure th...
  • ryan_mayu's avatar
    5 years ago

    gsamaral77 

    is this what you want?

    _MAX = MAX('Table (2)'[VELOCITY])
    
    _point = 
    MAXX(FILTER('Table (2)','Table (2)'[TAG]=max('Table (2)'[TAG])&&'Table (2)'[VELOCITY]=CALCULATE(max('Table (2)'[VELOCITY]),ALLEXCEPT('Table (2)','Table (2)'[TAG]))),'Table (2)'[Point])