DAX - Largest value from column

[Anonymous]

Dear Community,

i need your help with the creation of a DAX programming.
In the "Project_No" column there are many entries with the associated "Project_Step" column.
I need every single entry in "Project_No" with the corresponding highest entry in "Project_Step".
It can also be that 000 is the highest value. All other values should be hidden.

I would be glad if you can help me, Thank you

[amitchandak · Accepted solution]

@Anonymous , Create a measure like this and use it with project_no

Last step = calculate(max(Table[Project_Step]), filter(Table, Table[Project_Step] = calculate(max(Table[Project_Step]), allexcept(Table, Table[Project_No]))) )