Find MAX from a column based on filters from two other columns

[bournes2511]

Hi All,

I have searched high and low but I have yet to find anything that works for this.  I have two tables with a relationship.  Table 1 has an ORDERID that I need to find the last ID for based on two columns from Table 2, UNITID and PMCODE.  So basically, I need the last ORDERID for UNIT "X" and PMCODE "X".  I tried the formula below and it worked to get the last one for the PMCODE, but it did not tie in the UNITID so it just pulled the last ORDERID for whatever PMCODE I was looking at.  Using this formula, how could I also filter based on UNITID?

Last RO = CALCULATE(MAX('RO''s'[repair_orders.id]),FILTER(ALL('RO''s'), 'RO''s'[repair_orders.tasks.labor_system_component_code] = SELECTEDVALUE('PM''s'[scheduled_maintenance.system_component_code])))

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523