Create True/False filter

[Anonymous]

Hello, 

I have question regarding creating true/false filter based on all columns in data set. 
I have heat table visual (I can do it with matric table as well) where I follow 1&0 values for each column by week. 
I want to filter out if one or multiple columns have values 1 or 0 if possible? 

Here is visual without any filters

Any idea how should I enable that in my pbi report? 
Thanks!

[PowerUserR]

Hi,

I am not entirely sure of you intentions here. Are you trying to make a filter that checks if there are any 1's in the columns and returns (1) or True, otherwise (0) False? If so, I would recommend making a calculated column that sums up the rows and use that for filtering.