need urgent help power bi

[ghayma152]

I have two important tables: PhysicalParts, which contains the columns BuildId, PHPID, CurrentStep, and CurrentRank, and PHPStepDetails, which contains the columns PHPID and OpRank. My objective is to display, for each BuildId, the maximum value of PHPID, and also retrieve the corresponding value of CurrentStep when OpRank equals CurrentRank. However, I've encountered some difficulties. Despite my attempts, I haven't been able to obtain the expected result. Specifically, I'm unable to retrieve the CurrentStep value corresponding to the condition OpRank = CurrentRank.

[foodd]

What is your question? What have you tried and where are you stuck?

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.