How to write measure with Multiple queries and OR

[namitajuneja]

I have to find missingmanagers name but on the basis of different condtions.

1.When Contract type are T,M and column A has value X. I count   missing managers

2.the other condition id when contract type is C  and column B has value Y . I count  missing maangers.

And both these coditions should be in OR.

Can someone please help me . Its quite urgent. struggling from many days

[amitchandak]

@namitajuneja , Try a measure like

calculate(countrows(Table), filter(Table, (Table[Contract type] in {"T", "M"} && [Column A] = "X" ) || (Table[Contract type] ="C" && [Column B] = "Y" )  ))