Forum Discussion

harirao's avatar
harirao
Post Prodigy
5 years ago
Solved

Remove duplicate rows in table (group by)

Hi All,

 

I am working on table, required your assistance,

a) I want to summarise rows which are same and showing blank Eg:
There should be only one row for Raw Drive 819205-002 having 3 rows Cost column should be 934(161+191+582).Thanks for your help in advance.

 

Regards,

Hari 

Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    harirao 
    1. Select sum to aggregate the field


    2. Or Create a cost measure 

    Cost Measure = CALCULATE(SUM([Cost]),FILTER('Table','Table'[Raw drive]=MAX([Raw drive])))

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

3 Replies

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    harirao Have you tried to create hierachy in the data also will it be possible for you to share your data in text format or powerbi file.

    • harirao's avatar
      harirao
      Post Prodigy
      5 years ago

      Hi negi007 ,

       

      I tried with hierachy that also not working, i am unable to share data trough text or power bi file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    harirao 
    1. Select sum to aggregate the field


    2. Or Create a cost measure 

    Cost Measure = CALCULATE(SUM([Cost]),FILTER('Table','Table'[Raw drive]=MAX([Raw drive])))

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.