Last Modified Date: 09 Feb 2018
- Tableau Desktop
- FIXED Level of Detail expression (LOD)
- Dimension or measure filters
Option 1Add dimension and measure filters to context by right clicking on the field on the Filters Shelf and choose "Add to Context".
Note: This option will not filter LOD functions that are inside of another context filter.
Option 2Add the filtered fields to the dimension declaration of the FIXED LOD calculation. An example can be reviewed in the attached workbook. Note, adding fields to a FIXED LOD will affect the level of computation and therefore may change the results of the calculation.
Option 3If using a dimension filter, modify the LOD to use INCLUDE or EXCLUDE instead of FIXED. This may change the results of the LOD calculation depending on the structure of the view.
Note: EXCLUDE and INCLUDE will not be filtered by Measure filters
CauseThe FIXED expression ignores the fields in the view, which includes fields on the Filters Shelf. Options 1 and 2 leverage the order of operations for computing a view:
- Filters added to context
- LOD calculations
- Regular dimension and measure filters
- Remaining calculations
The workaround related to option 3 leverages how INCLUDE and EXCLUDE work. The INCLUDE and EXCLUDE LOD expressions take into account the fields in the view, which includes fields on the Filters Shelf.
Additional InformationBora Beran: What's new in Tableau 9.0? Part 2 - Level of Detail Expressions
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials