Tableau FIXED LODs Not Filtering (Dimension and Context Filters)

🔔 Book a FREE 15-min Tableau call here: https://forms.gle/DfW6TJkMjsmBytig8

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.

Connect with us:
•Book an hour to work with Ollie: https://onenumber.biz/office-hours
•Upcoming Tableau Classes: https://onenumber.biz/onenumber-table...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn:   / oliverlinley  

Resources:
•Example Tableau Workbook: https://public.tableau.com/app/profil...
•FIXED Level of Detail Expressions: https://onenumber.biz/blog-1/2024/3/1...
•Discrete vs. Continuous: https://onenumber.biz/blog-1/2022/5/2...