In Tableau, a fixed calculation is a type of calculation that allows users to perform aggregations or calculations at a specific level of detail, while ignoring the other levels of detail in the data. The fixed calculation is denoted by the FIXED keyword, followed by the level of detail and the aggregation or calculation to be performed. The syntax of a fixed calculation is as follows:
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. tableau fixed calculation