(Slice) Equation help needed: Need a This or That

I have myself stumped here.
I need to a little help with a slice.
the goal is to pull 2 possible parameters
the current equation:
COUNT(SELECT(Orders[Order Id],AND([_THISROW].[Customer ID]=[Customer Name],[Order Status]=“Ready for Takedown”,[Install Team]=“Hotshot”)))>0

So in the above, we return a customer, that is in the status column with ready for takedown, and the install team Hotshot.

Now I want to return a customer, ready for takedown, with ether Install Team Hotshot or Red.

How would I do this.

Thanks Community! I am just stumped here.

0 2 243
2 REPLIES 2

Steve
Participant V

Here’s your original expression reformatted for clarity:

COUNT(
  SELECT(
    Orders[Order Id],
    AND(
      ([_THISROW].[Customer ID] = [Customer Name]),
      ([Order Status] = “Ready for Takedown”),
      ([Install Team] = “Hotshot”)
    )
  )
)
> 0

And here it is with your new requirement:

COUNT(
  SELECT(
    Orders[Order Id],
    AND(
      ([_THISROW].[Customer ID] = [Customer Name]),
      ([Order Status] = “Ready for Takedown”),
      OR(
        ([Install Team] = “Hotshot”),
        ([Install Team] = “Red”)
      )
    )
  )
)
> 0

Read more:

Thank you so much! That did it!!!
Very Big help Steve, I was just looking over the obvious.

Top Labels in this Space