SLICE OF INTERSECT VALUES FROM 2 OTHER SCLIES BUT THE SAME TABLE

[Tom_Stevens]

I have a table called:  "TIME LOG" - It's basically a time sheet

Columns as follows:

KEY ID	NAME	JOB NUMBER	DATE	RTI
A simple Key ID	An employees name	A number from 1 to infinity. The same number may occur multiple times.	yyyy/mm/dd	true or false

From that table I have 2 slice views:

"TIME NOT READY" - It shows all of the entries marked as "false" for RTI.

"TIME READY" - It shows all of the entries marked as "true" RTI.

I would like to have a third slice view that shows only those numbers that have time noted as both true & false. Example data:

KEY ID	NAME	JOB NUMBER	DATE	RTI
ab123e	Jane	2232	2022/08/22	true
ergg83	Jane	2232	2022/08/22	true
vfjer83	Bob	5000	2022/08/22	false
sef344	Pat	2230	2022/08/22	true
fgh4e4	Kelly	2232	2022/08/22	false
e42e44	Cally	2230	2022/08/22	true

So in this case the new slice would only show 3 entries, Jane & Kelly's job number "2232". It is the only entry that shares a job number, but where the RTI's are not all the same (but a mix of true and false).

I'm just drawing a blank as to what I should have as the filter condition for the slice in order to show this. 

[MultiTech · Accepted solution]

AND(
  IN([RecordID], Slice_1[RecordID]), 
  IN([RecordID], Slice_2[RecordID])
)

You could also use Intersect() if you wanted:

Intersect(
  Slice_1[RecordID],
  Slice_2[RecordID]
)

I imagine Intersect() would be the "simplest" version of things

[Tom_Stevens]

AND(
IN([KEY ID], TIME NOT READY[KEY ID]),
IN([KEY ID], TIME READY[KEY ID])
)

Seems to be working. 

Interstect(), which I had tried before, was giving me an error. "The expression is valid but its result type 'List' is not one of the expected types: Yes/No"

Thanks for the help!

[MultiTech]

---

@Tom_Stevens wrote:

Interstect(), which I had tried before, was giving me an error. "The expression is valid but its result type 'List' is not one of the expected types: Yes/No"

---

• Absolutely my fault.  My bad!

IN([RecordID], 
Intersect(
  Slice_1[RecordID],
  Slice_2[RecordID]
))

• Intersect finds the common values, then you check to see if the current record is in that list.

[Tom_Stevens]

LOL, appreciated. It's how I felt when I couldn't see the forest for the tree's. Knowing full well that I had filtered something similar in an older app but couldn't recall for the life of me what I had done. 

Thank you again.