cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
guilledo24 Frequent Visitor
Frequent Visitor

New column with total by id

Hi,

I have the next table

 

ID  |  SALES

1   |    123

2   |    50

1   |    08

3   |    26

3   |    74

2   |    12

1   |    59

 

And i need to create a new column to have the total sales by id, repeat the total in every id:

 

id  |  SALES  |  TOTAL

1   |    120    |    810

2   |    500    |    620

1   |    100    |    810

3   |    260    |    1000

3   |    740    |    1000

2   |    120    |    620

1   |    590    |    810

3   |    590    |    1000

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Phil_Seamark Super Contributor
Super Contributor

Re: New column with total by id

Hi @guilledo24

 

I think this calculated column gets pretty close

 

Total = 
    CALCULATE(
        SUM('Table1'[Sales]), 
        FILTER(
            'Table1',
            'Table1'[ID]= EARLIER(Table1[ID])
            )
        )

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

4 REPLIES 4
Phil_Seamark Super Contributor
Super Contributor

Re: New column with total by id

Hi @guilledo24

 

I think this calculated column gets pretty close

 

Total = 
    CALCULATE(
        SUM('Table1'[Sales]), 
        FILTER(
            'Table1',
            'Table1'[ID]= EARLIER(Table1[ID])
            )
        )

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Community Support Team
Community Support Team

Re: New column with total by id

Hi @guilledo24

 

guilledo24 Frequent Visitor
Frequent Visitor

Re: New column with total by id

Can you explain me all the formula?

guilledo24 Frequent Visitor
Frequent Visitor

Re: New column with total by id

@Phil_Seamark thanks for answering, that solution it's excelent.

 

Now I need the same result but the total sales by id, month and year, can you give me the best solution?

 

id  |  SALES  |  MONTH  |  YEAR

1   |    120    |    2           |   2018

2   |    500    |    6           |   2017

1   |    100    |    3           |   2018

3   |    260    |    3           |   2017

3   |    740    |    2           |   2018

2   |    120    |    2           |   2017

1   |    590    |    6           |   2017

3   |    590    |    2           |   2018