Report Portal

Apply AND Logic to Multiple Selection in DAX Slicer

When you apply a multiple selection to a slicer or to a filter, you obtain a logical OR condition between selected items. This article shows how to implement a logical AND condition in a measure instead of the standard OR one.

 

Slicers and filters in a report provide a user interface to select one or more items from an attribute, which is applied as a filter to the measures used in the report itself. In case the user selects two or more items from the same slicer or filter, each measure evaluates a selection applying a logical OR condition between the selected items.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.