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.
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.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |