The column drags from the table NOT filtered by the slicer

[sy84]

Hi all, could you please take a look and help me to suggest a solution? Many thanks in advance. 

This is the dataset: 

User ID	Range	Parcel Included	Rank	Quantity
Mary	Food	False	2	1
Mary	Cooking	True	2	1
Mary	Services	True	2	2
Mary	Kitchen	False	1	3
Tom	Kitchen	False	2	2
Tom	Decoration	True	2	2
Tom	Plants	True	2	6
Nina	Cooking	False	1	1
Nina	Plants	False	1	7
Nina	Bathroom	False	2	2
Nina	Decoration	False	2	6
Nina	Services	False	2	8
Nina	Food	False	2	4

1. The slicer - <Parcel included> set to True;

2. Create a measure called Quantites. So the table visual should be User ID, Range and measure - Quantities; 

3. We use the Mary as an example. The current measure I wrote can show Mary only with Cooking and Service since the slicer sets to True thus Food is removed. But I want to include Food in the table visual since its Rank = 2. 

This is the table visual I want to be like: 

User ID	Range	Quantity
Mary	Food	1
Mary	Cooking	1
Mary	Services	2
Tom	Kitchen	2
Tom	Decoration	2
Tom	Plants	6

[parry2k]

@sy84 also in  your output example why Nina records are not showing which has rank = 2

[sy84]

Thank you for your reminder. I changed the scenario a bit and mark all rows of Nina as False in column Parcel. 

[parry2k]

@sy84 in this case you have to have disconnected table for the parcel and use that for slicer and then tweak the measure to see what Rank items to include.

[sy84]

Thank you for your reply. But I want to use parcel to filter out those qualified user IDs since NOT every User having TRUE (It might some users have all rows = FALSE).