Syntax/measure for calculated column with filters

[pigsinblankets]

Good morning, 

Is there an easy measure or calculated column to calculate a column if multiple filters apply from other columns? 

E.g. calculate column A when column B is filtered on 1 & column C is filtered on 2 and Column D is filtered on 3 etc. 🙂

[Idrissshatila · Accepted solution]

Hello @pigsinblankets ,

yes, 

calculated column = CALCULATE(Sum(A),TableName[B]=1,TableName[C]=2,TableName[C]=3)

you can replace sum with the aggregation you want.

[pigsinblankets]

@Idrissshatila - Thank you 😊