Forum Discussion
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...
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])
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])