Creating Measure for FILTER with Multiple Column with multiple filter options

[acerNZ]

CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1]="Completed"))) -- > Works (For one column)

but I need to filter and combine with 3 other options of 2 other columns

Please may I know how ?

But I have Col1 - > 2 filters AND (Table[COL1] ="Yes", Table[COL1] ="Not Sure")

Col2 -> AND(Table[Col2]="Yes", Table[Col2]<>"Not Sure", Table[Col2]="Parked")

Col3 -> AND(Table[Col3]="No", Table[Col3]<>"No Order ", Table[Col3]="New York")

Please may I know how to combine all above to create a measure to be used.

Thanks a ton

[amitchandak · Accepted solution]

@acerNZ ,

Two tbale values can not be and , they need Or or IN

example 

CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"})))

CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"})))

1 or 2

CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"}) || (Table[Col2]="Yes" || Table[Col2]<>"Not Sure" || Table[Col2]="Parked") ))

1 and 2

CombineMeasure = CALCULATE(COUNT(Table[COL1]),FILTER(Table,(Table[Col1] in {"Yes", "Not Sure"}) &&  (Table[Col2]="Yes" || Table[Col2]<>"Not Sure" || Table[Col2]="Parked") ))

add in this way