Re: (Slice) Equation help needed: Need a This or T...

Brennan_Morrow · 12-29-2019 01:10 PM

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.

Steve

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

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