Remove Duplicate Id and retrieve max

[BharathM]

Hi Everyone
I need a measure to retreve the max of ID based on max column and date 

I have ID,MAX,DATE columns here my requirement is to remove the duplicate ID's based on max column

should show only the max of id and date 

Desired Output 

But one more thing i want to remove the max column in visual please give me suggestion for that 

[tamerj1 · Accepted solution]

Hi @BharathM 
Please place the following measure in the filter pane of the table visual, select "is not blank" and apply the filter

FilterMeasure =
VAR MaxMax =
    CALCULATE ( MAX ( 'Table'[MAX] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) )
RETURN
    COUNTROWS ( FILTER ( 'Table', 'Table'[MAX] = MaxMax ) )

[BharathM]

Thank You so much dude its working 
Again Thanks for speed reply