Forum Discussion
Filter table on multiple Boolean columns
I'm following this posting. I created my measure but P-BI will not allow me to add the measure as a filter.
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".
5 Replies
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.
Why didn't "super user" state that in their solution? I'm attempting to accompilsh the same thing.
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".
Further to this have a read of https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/