Forum Discussion
pigsinblankets
2 years agoHelper II
Syntax/measure for calculated column with filters
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 & colu...
- 2 years ago
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.
Idrissshatila
2 years agoSuper User
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.
- pigsinblankets2 years agoHelper II
Idrissshatila - Thank you 😊