Table Interaction / Filter

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)

 

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

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