Clustered Barchart using sum of Boolean ( 1 or 0 ) when drilling down does not just show True

[Duffster]

I am really hoping someone can help with an issue that I am really struggling to resolve in my Power Bi ? 

I have a datamodel that has a number of fields identified as 1 or 0 example below 

when I create a clustered barchart including the Sum of these values as below I would expect Clicking on each one of the clusters would filter the underlying table , for the respective column and only show the positive values ( 1 ) however it shows both the 1 and zero data. 

so in the above example I would like to just show the 5 Records in the table where OOF180 = 1 

Is this possible ?? 

Many thanks for any help in advance 

[VijayP · Accepted solution]

@Duffster 

I think I found a simple way

in first place you have to unpivot you are all boolean columns into one single column and then

instead of normal table use the matrix table and you will get the required result

you can use the uploaded file

[VijayP]

@Duffster 

Since you have created a series like APPPS etc and added datapoints to it , when you try to filter entire series will get filtered. So it shows values of all datapoints of that series that is why you are not able to see only 1s or 0s.

Need to see, but it is possible thru dax alongwith slicer

[Duffster]

Many thanks for such a prompt reply @VijayP.  re Need to see, but it is possible thru dax alongwith slicer

Could you elaborate on the method to apply using dax and slicer please ? 

If you need to see anything else let me know I can update the original question - Once again thanks