All in Level of Detail

Tableau FIXED LODs Not Filtering (Dimension and Context Filters)

Ollie Linley
Level of Detail

FIXED LODs are wonderful because they allow us to aggregate our measures at a chosen Dimension level, regardless of the level of detail of the worksheet. However, they aren't affected by Dimension Filters, because they're calculated before Dimension Filters are processed.

There are various scenarios where we need to work around that. We'll use Context Filters to help us where we need our LODs to be filtered, and we'll take a look at an example where you might not want your LOD to be filtered by your Dimension Filters.

How FIXED Tableau Level of Detail Function Works

Ollie Linley
Level of Detail, Table Calculations

FIXED Level of Detail Functions (LODs) let you specify the level of detail you want to aggregate a particular measure at. This allows us to work around the natural limitations of the level of detail in the worksheet we're working in.

FIXED LODs are a great place to start as they are the definitive, essential LOD. The two others (EXCLUDE and INCLUDE) are less common, but functional in their own unique ways. If you want to simplify and just learn one LOD type, FIXED is the one for you!