Use a slicer to find all customers who bought that item on a given day with the other items included

jjkmd — Mon, 18 Nov 2019 15:51:27 GMT

I'd like to use a slicer to show all the customers on a given day who bought a certain product, but include all the other product sales in the total. ie, select all the ones that contain a value, and not filter out the others.

Sample example data

Date	Customer	Color	Item	Payment
1/1/2019	John	Red	Shirt	1
1/1/2019	John	Red	Shoes	3
1/1/2019	Betty	Blue	Shirt	2
1/1/2019	Betty	Blue	Shoes	3
1/1/2019	Betty	Blue	Pants	4
1/1/2019	Mike	Blue	Shoes	3
1/1/2019	Mike	Blue	Pants	4
1/2/2019	John	Blue	Shirt	1
1/2/2019	Betty	Blue	Shoes	3
1/2/2019	Betty	Blue	Pants	4
1/3/2019	Peter	Blue	Shirt	2
1/3/2019	Peter	Red	Shirt	2
1/3/2019	John	Red	Shoes	3
1/3/2019	John	Red	Pants	4

So, if I used a slicer with Shirt - Shoes - Pants, and chose "Shirt", the total for 1-1-19 would be all the payments for John and Betty, but not Mike (he didn't buy a shirt on 1-1-19). Total would be $13, and if I put the name into the visual it would show $6 for John, $7 for betty on this day.

ON 1-2 it would include John alone and show $1 etc.

AND I could then show a table that looks like this

Date	Customer	Color	Item	Payment
1/1/2019	John	Red	Shirt	1
1/1/2019	John	Red	Shoes	3
1/1/2019	Betty	Blue	Shirt	2
1/1/2019	Betty	Blue	Shoes	3
1/1/2019	Betty	Blue	Pants	4
1/2/2019	John	Blue	Shirt	1
1/3/2019	Peter	Blue	Shirt	2
1/3/2019	Peter	Red	Shirt	2

That shows all the details but only if there was a shirt purchase in there.

I saw somewhere months ago about using a slicer on a table that was not linked to the other tables would allow for a slicer to be used this way, but I can't find the post/blog or recreate the syntax from memory.

topic Use a slicer to find all customers who bought that item on a given day with the other items included in DAX Commands and Tips

Use a slicer to find all customers who bought that item on a given day with the other items included