KNOWLEDGE BASE

Automatic Grand Total does not Change as Expected when Changing Parameter Value


Published: 10 Oct 2019
Last Modified Date: 11 Oct 2019

Issue

When adding a grand total to a view with at least one measure with COUNTD(), and a measure filter, then swapping the dimension values in the view by changing a parameter selection, the grand total does not update to reflect how the measure filter is now computing the measure.

Environment

Tableau Desktop

Resolution

As a workaround, add a level of detail (LOD) calculation to Detail on the Marks card that fixes an expression to the calculation that swaps between dimension values. To view an example, see the attached LOD on Detail workaround.twbx workbook.

Cause

This is issue (ID 920395) is currently under investigation
Did this article resolve the issue?