Return critical point

[gsamaral77]

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?

[gsamaral77]

It's work! Thanks!!!

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@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])