cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Creating Column to Evaluate field using OR or similar function

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Creating Column to Evaluate field using OR or similar function

@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" } ) ```

Proud to be a Datanaut! Kudos Help
Connect with me on Linkedin. Feel free to email me with any of your BI needs.

2 REPLIES 2
Member

## Re: Creating Column to Evaluate field using OR or similar function

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).

Super User

## Re: Creating Column to Evaluate field using OR or similar function

@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" } ) ```