Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    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's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

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.