Forum Discussion

pbiwizard's avatar
pbiwizard
Frequent Visitor
3 years ago
Solved

Group by, Removing Duplicates, and Adding Rows

Hi!  I am looking for help with removing duplicates when grouping, and adding a column. Or however, I can achieve the second table (i just started off with group-by and summing but that did not work...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    pbiwizard You don't need to create a new table, just add measure for each column and then use that in the visual, here is the example of the measure for Gross Sales

     

    Gross Sales M = 
SUMX ( 
    SUMMARIZE ( TableSum, TableSum[Key ID], TableSum[Gross Sales] ), 
    [Gross Sales] 
)
parry2k's avatar
parry2k
Super User
3 years ago

pbiwizard You don't need to create a new table, just add measure for each column and then use that in the visual, here is the example of the measure for Gross Sales

 

Gross Sales M = 
SUMX ( 
    SUMMARIZE ( TableSum, TableSum[Key ID], TableSum[Gross Sales] ), 
    [Gross Sales] 
)