Remove duplicate rows in table (group by)

[harirao]

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 

[Anonymous · Accepted solution]

@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.

[negi007]

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

Hi @negi007 ,

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