Remove duplicates from the dataset

[pabburi]

From the given dataset i need filter out the duplcates and from the output i need to develop the visualization.Plese help me out.

[Phil_Seamark]

Hi @pabburi

For the two rows highlighted for Raju?  Do I take it the reason why the 2nd row is kept and the first row is discarded because 60 is higher than 55?

[pabburi]

Hi Phil,

Thank you for the time.

Yes applicationID 11 is consider to percantage 60 because of its higher value.

[Phil_Seamark · Accepted solution]

Hi @pabburi,

Here is one way.  Create a calculated table using the following code

Table = 
    SUMMARIZE(
        'Table1',
        'Table1'[ApplicationID] ,
        'Table1'[Manager] ,
        "Percentage" , MAX('Table1'[Percentage]
        )
        )

[pabburi]

It worked.

Thank you Phil