Nov 10, 2015NEXT WORKSHOPS: | 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.
» READ ARTICLE | Unexpected filter behavior in CALCULATE
| Filters in CALCULATE override previously existing filters on the column they use. | For example, CALCULATE ( [Sales], Product[Color] = “Red” ) returns red sales, no matter what you filter in a pivot table. Nevertheless, this golden rule sometimes looks not to work as expected, and it is time for another puzzle! » TEST YOUR SKILLS | Last seats available!
| Learn BI with video courses Don't miss new courses by Chris Webb: The coupon is valid for Full Access Year Memberships and allow you to access all the courses on Project Botticelli site. | 50% OFF on these eBooks:
50% OFF Coupon ECD2EBKS50 Valid until Nov 17, 2015 |
|