Creating Column to Evaluate field using OR or similar function

Question

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 Answer

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
&nbsp;
MidOfc Count = CALCULATE(MktShr[Deal Count], MktShr[Product Group] IN
{ "Mid Office" , "Mid-GD" , "next value", "next value" } )

Forum Discussion

Creating Column to Evaluate field using OR or similar function

2 Replies

Related content

Lazy evaluation

Function Library - Create and Maintain

can't create a udf function

Dataflow evaluation error

Expression Evaluate , error