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

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.