The phrase "fixed in tableau" could be interpreted in a few ways, but I'll offer a piece of writing that captures a moment or scene where something or someone is fixed or frozen in a tableau, akin to a scene from a painting or a snapshot in time. This interpretation leans towards a poetic or descriptive piece:
The easiest way to understand FIXED is to visualize a mini-query happening inside your main visualization. fixed in tableau
In Tableau, is a type of Level of Detail (LOD) expression that allows you to calculate aggregations at a specified dimension level, ignoring other dimensions in the view. It gives you precise control over your calculations, independent of the worksheet’s filtering or granularity. The phrase "fixed in tableau" could be interpreted
Because is computed before Dimension Filters, your Fixed calculations will often ignore your filters. This causes confusion for beginners. It gives you precise control over your calculations,
FIXED tells Tableau to ignore the view's level of detail.
You have a filter for "Year = 2023". You create FIXED [Region] : SUM([Sales]) . Your view shows numbers that look too high. Why? Because the FIXED calculation summed up sales for 2021, 2022, AND 2023, ignoring your Year filter.