Forum Discussion

pabburi's avatar
pabburi
Frequent Visitor
8 years ago
Solved

Remove duplicates from the dataset

 

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

 

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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]
        )
        )

4 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    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's avatar
      pabburi
      Frequent Visitor
      8 years ago

      Hi Phil,

       

      Thank you for the time.

       

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

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        8 years ago

        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]
        )
        )