Keep rows with unmatching data when filtering

I'm wondering how you would select the color yellow, if the color is just in your sales-table, but no yellow bikes have been sold sofar.

I personally would no relate the sales and the targets table, but would use separate "dimension" tables like "product" and "year", then you can relate these tables to your "fact" tables: sales and saltestargets. Then you can use the color column from the sales-facts to slice your sales data.

Please be aware, that in my example the direction "Cross filter direction" of the relationships should be set to "Single".

Hope this helps

Agree with Tom. This link might be helpful: http://exceleratorbi.com.au/multiple-data-tables-power-pivot/