Creating Column to Evaluate field using OR or similar function

[ecl]

I need to create a new Calculated Column that counts the occurences of another field with six arguments. First tried using the OR function. But, the OR function only works with two arguments and I need to evaluate six. Here is the formula I started with.

MidOfc Count = CALCULATE(MktShr[Deal Count], OR(MktShr[Product Group] = "Mid Office",MktShr[Product Group] = "Mid-GD"))

The table is called MktShr with a couple fields in use. There is a Column named [Deal Count] that is simply counting the number of rows. Another field named [Product Group] that contains information that needs to be evaluated for six values including: Mid Office, Mid-GD, Mid-Compliance, etc. 

Help is appreciated.

[parry2k · Accepted solution]

@ecl you can use || for OR instead of using OR function

MidOfc Count = 
CALCULATE(MktShr[Deal Count],
MktShr[Product Group] = "Mid Office" || MktShr[Product Group] = "Mid-GD"
|| …. 
)

you can also use IN

MidOfc Count = CALCULATE(MktShr[Deal Count], MktShr[Product Group] IN
{ "Mid Office" , "Mid-GD" , "next value", "next value" } ) 

[Gordonlilj]

Hi,

Try something like 

CALCULATE(MktShr[Deal Count], FILTER(MktShr[Product Group] = "Mid Office" || MktShr[Product Group] = "Mid-GD"

|| MktShr[Product Group] = "Mid-Compliance" || MktShr[Product Group] = "Value4" || MktShr[Product Group] = "Value5" || MktShr[Product Group] = "Value6")). 

Just change "Value#" and it should work (if i understood the issue correctly).