cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ecl Frequent Visitor
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
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" } ) 




Did I answer your question? Mark my post as a solution.

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




 




2 REPLIES 2
Gordonlilj Member
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
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" } ) 




Did I answer your question? Mark my post as a solution.

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