KNOWLEDGE BASE

Tableau Quits Unexpectedly or Error "Field [field] which is included for filtering does not exist" Using Calculation as Filter


Published: 22 Feb 2018
Last Modified Date: 05 Oct 2018

Issue

When using an aggregated calculation as a filter on a worksheet with "aggregate measures" deselected, Tableau Desktop may unexpectedly stop or the following error occur:

The filtering operation did not complete successfully because of an unexpected error.
Field 'usr:Calculation_734368252571582464:nk' which is included for filtering does not exist
.

Note: the number in the field name may change.
 

Environment

Tableau Desktop

Resolution

Option 1

Upgrade to Tableau Desktop 2018.1.1, 10.5.4, 10.4.7 or a later version. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

Select Analysis > Aggregate Measures, then recreate the view. 

Option 3

Change the SUM([measure]) field on the view to a Continuous Dimension.

Cause

When "Aggregate Measures" is deselected, Tableau Desktop cannot create the temporary calculation that it needs in order to properly compute the values for an aggregated calculation.

This behavior is related to a known issue (ID: 742812  which has been fixed in a recent release of Tableau Desktop. 

 
Did this article resolve the issue?