Tableau Fixed Calculation _verified_ Info

If you drag AVG([Sales]) into the view, Tableau calculates the average of the records currently in the view. If you filter by Region, the average changes. You want the "Global Average" to stay static.

| Pitfall | Why it happens | Fix | |---------|----------------|-----| | | FIXED ignores dimension filters | Move filter to Context or use INCLUDE/EXCLUDE | | Unexpected repeated values | Row-level vs aggregated calculation | Place FIXED on Detail or use as a measure | | Slow performance | Computes across entire data source | Limit dimensions, use extracts, or pre-aggregate | tableau fixed calculation

Powerful but requires careful filter handling. Excellent for dimension-specific constants across views. If you drag AVG([Sales]) into the view, Tableau