Forum Discussion

pigsinblankets's avatar
2 years ago
Solved

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...
  • Idrissshatila's avatar
    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.