Filter row only when one column week is 0 (weeks widely pivoted)

[mtens17]

I have a table with each week and below certain measures as columns. This table is grouped by countries and shows subtotals. I can't filter measures if I want to show subtotals.

Therefore, I have made a table calculation that checks if at least one measures is > 0 and states Yes if so.

I want to filter out rows if in all the weeks of the row I have a No in that check column. If there is just one Yes, I want to keep the whole row (even with empty weeks). 

Is there a way to do that? Thanks