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. https://community.powerbi.com/t5/Desktop/Filter-Table-based-on-multiple-True-False-col...
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".
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.
Why didn't "super user" state that in their solution? I'm attempting to accompilsh the same thing.