Create a measure for a unpivoted column, with repeating ID values?

[Anonymous]

I have a table with unpivoted data, shown below. The ID column has repeat values because the transaction goes through several stages captured in the Process Step column

My objective: Create a measure that calculates the maximum date from the Status Change Date Column, but only for Upload and "Approval" Process Step. So, where Process Step is Upload OR Approval, Max(Status Change Date)

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download sample PBIX file

Is this what you are after.  If it is not, please show an example of your expected result.

Max Date = CALCULATE(MAX('Table'[Status Change Date]), FILTER(ALL('Table'), 'Table'[Process Step]="Approval" && 'Table'[Transaction ID] = SELECTEDVALUE('Table'[Transaction ID])))

Regards

Phil