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 that return the critical velocity with MAX
But when I put the column "Point" appear all the measures
Someone can help me please?
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])
3 Replies
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])It's work! Thanks!!!
you are welcome
