I'd like to get the total value taking into account 2 or more columns

[Achartuni]

Hello

Given the data below I'd like to et the total of "valor" grouped by year and university. 

Say if I have this sample of data, the desired result is stored in the D column

A  |  B  |  C  | D

2  |  X  |   5  | 5   

3  |  X  |   5  | 5

2  |  Y  |   5  | 10

2  |  Y  |   5  | 10

[Zubair_Muhammad · Accepted solution]

@Achartuni 

Try following

=Calculate(sum(TableName[ColumnC]),allexcept(TableName,TableName[ColumnA],TableName[ColumnB]))

[Achartuni]

Thanks! It solves the issue I was having with my data.

Is there any other way to do it? I am starting with Power BI and I'd like to know if there's any othe way to achieve this, thanks in advance!

[Zubair_Muhammad]

@Achartuni 

Another way as a calculated column could be

=
CALCULATE (
    SUM ( TableName[ColumnC] ),
    FILTER (
        TableName,
        TableName[ColumnA] = EARLIER ( TableName[ColumnA] )
            && TableName[ColumnB] = EARLIER ( TableName[ColumnB] )
    )
)

[Achartuni]

Thanks! Could you explain the EARLIER? I don't seem to get its functionality quite right