Fixed In Tableau

Create a calculated field for the denominator.

This calculates the total sales per region. Even if you filter out "Furniture" from the view, this calculation still includes Furniture in the sum because of how FIXED interacts with filters (see section 5). 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. Create a calculated field for the denominator