Tableau Fixed [better]

The FIXED function in Tableau is a type of aggregation function that allows you to perform calculations at a specific level of granularity, while ignoring the other levels of granularity in your data. It's commonly used to calculate values that are specific to a particular dimension or set of dimensions, without being affected by the other dimensions in your view.

: A standard Tableau quick table calculation for "Percent of Total" will change if you filter out a category. By using FIXED : SUM([Sales]) as your denominator, you can keep the total stable even when filters are applied. tableau fixed

FIXED [dimension(s)] : expression