How to use OR between dimension filters in Report Builder

Question

How can I choose an "And" or "Or" between dimension filters in Report Builder using an SSAS tabular model .

Answer 1

To use "Or" between dimension filters in Report Builder using an SSAS tabular model, you can follow these steps:

1. Open your report in Report Builder.
2. Drag a dimension field into the Filters area of the tablix or chart you are working on.
3. In the Filter dialog box that appears, click on the "Dimension" tab.
4. In the "Dimension Filters" section, click on the "Add" button to add a new filter.
5. In the "Values" column of the new filter, select the values you want to include in the filter.
6. By default, the operator between filters is set to "And." To change this to "Or," click on the "Operator" dropdown menu and select "Or."
7. Click OK to save the filter.
8. If you need to add additional filters with an "Or" operator, repeat steps 4-6 for each filter.

Note that when you use the "Or" operator between filters, the filter will return any rows that match any of the selected values in any of the filters, rather than only returning rows that match all of the selected values in all of the filters.

Also, keep in mind that the specific steps for setting filters in Report Builder may vary slightly depending on your version of the software.