SumIf depending of a column

[cristianml]

Hi,

I need to calculate like a Sumif but depending of a column. See example below.

Table1

How can I do this ? by measure or calculated column ?

Thanks !

[Tahreem24]

@cristianml Try the below DAX measure:

MEASURE = CALCULATE(SUM(TableName[ValueColumn]),ALLEXCEPT(TableName,TableName[QuarterColumn]))

[amitchandak · Accepted solution]

@cristianml ,

Sumx(filter(allselected(Table), Table[Qtr] = max(Table[Qtr]) ) , Table[Value])