Table Interaction / Filter

[Kurt4597]

Hello,
I Have been stuck on this issue for a few days now, not entirely sure if what I am after is even possible. If anyone could assist It would be massively appreciated

File Used: https://easyupload.io/m3v8sm

Table Used
I have one table of data, no relationships to anything else

I also have the following measures 

Red Items = CALCULATE(COUNTROWS('Item List'),'Item List'[Red] = true)
Green Items = CALCULATE(COUNTROWS('Item List'),'Item List'[Green] = true)
Blue Items = CALCULATE(COUNTROWS('Item List'),'Item List'[Blue] = true)

I have now produced two visuals. The first visual table contains Retailer and the three measures created above. The second table is just all data from the original table

-----------------------------------------------------------------------------------------------------

Desired Outcome 
When you select a number value in the table on the left, the table on the right filters accordingly.

For example, I selected Asda, Blue Items (Number 3 highlighted in Image) and the table on the right would filter for all instances where retailer = Asda and Blue Items = True

-----------------------------------------------------------------------------------------------------

Actual Outcome

The table on the right is only being filtered for for Retailer = Asda and not including the Blue = True part

 -----------------------------------------------------------------------------------------------------

Attempted Solution 1 - Filter on All Data Table

At first I thought I could apply a filter on the first table to show only where blue values = true. This would work for one colour however this does not work for multiple colours. If I filter the table for blue = true then this filters out instances of red = true and green = true. 

Attempted Solution 2 - Unpivot the raw data to create a seperate line for each instance
This solution may work on the sample data, however the original dashboard I am using this one has millions of rows and 20+ "Colour" columns so unpivoting it is not a viable option at the moment

[miTutorials · Accepted solution]

Please see the attached solution and see if this helps !! I have created a disconnected table and a measure to filter the table.

[Kurt4597]

Thank you! This was a huge help