filter on basis of multiple selections

[AbhinavSatija]

I need to Filter a table on the basis of one column( Lets say TYPE) which can have 10 different string values (ACROSS 1000 ROWS). Now I want to extract the rows that have the either of the following three values: Good, New, Perfect. My algorithim is like as:

ABC = CALCULATE(    SUM(PF[Contract Rentable Size]),

                                     PF[Type] = "GOOD",

                                   or  PF[Type]= "NEW" 

                                   or PF[Type]= "Perfect"

                          )   

[MattAllington]

try this

ABC = CALCULATE(
    SUM(PF[Contract Rentable Size]),
    PF[Type] = "GOOD" || 
    PF[Type]= "NEW" || 
    PF[Type]= "Perfect"
  )   

The double pipe is the OR operator (one of them anyway)