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

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

pabburi's avatar
pabburi
Frequent Visitor
8 years ago

It worked.

Thank you Phil