Filter table on multiple Boolean columns

[Anonymous]

I'm following this posting.  I created my measure but P-BI will not allow me to add the measure as a filter.

https://community.powerbi.com/t5/Desktop/Filter-Table-based-on-multiple-True-False-columns/m-p/65461...

https://app.box.com/s/bqal9kknqzyix03ehihjoqv1jjnyxjqe

[bcdobbs · Accepted solution]

Have now opened your file. It will let you put your measure into the visual filter section:

You can put a measure onto a visual that has a row context.

It won't let you put it onto a page filter because there is no "row".

[bcdobbs]

Further to this have a read of https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/

[Anonymous]

Hi @Anonymous 

Measures are designed to calculate value based on or selection not to be used as a selection in Slicer. This is one of the point where you can understand when to use a measure vs a column.
Change  to a column and use it in filter criteria.

[Anonymous]

Why didn't "super user" state that in their solution?  I'm attempting to accompilsh the same thing.

https://community.powerbi.com/t5/Desktop/Filter-Table-based-on-multiple-True-False-columns/m-p/65461...

[bcdobbs]

Not by a computer so will check your file later. However make sure your measure is returning 1 or 0 and data type is set as whole number. It won't let you use a measure as a filter if it returns Boolean.