Calculated column - MAX Completion date based on 3 columns

Hi Dima MD - i modified your PBIX and see image the measure does not work now... NUM 344 should return zero max date but we have a value

does your example return no max date when you have a 0 in date Check column. if yes can you provide a PBIX Please

Anonymous yes 

Also another slight change

Anonymous Ok, then you just need to remove the IF condition

MaxDate = 
         CALCULATE(
            MAX('table (2)'[ACTDate]), 
                FILTER( 'table (2)',
                'table (2)'[NUM] = MAX('table (2)'[NUM]) && 'table (2)'[ID] = 'table (2)'[ID]
            )
        )

i DimaMD

We ahve no ACTDate and a zero in Date Check the MAx date should be blank() see image below not 29.09.21