KNOWLEDGE BASE

Sort Order Ignores Calculated Members


Published: 15 Dec 2017
Last Modified Date: 16 Dec 2017

Issue

When connected to a MSAS data source and selecting a calculated member in a filter, then data is sorted by unfiltered values.

Environment

  • Tableau Desktop 
  • Tableau Server
  • Microsoft SQL Analysis Services (MSAS)

Resolution

For Tableau Desktop:

Option 1: Use the feature flag from the command prompt

  1. Open a command prompt as an administrator. 
  2. Navigate to C:\Program Files\Tableau\Tableau <version>\bin
  3. Run tableau.exe -DEnableMDXCalcSliceFiltering

Option 2: Create a shortcut with the flag enabled

  1. Right-click the alias and select Properties.
  2. Go to the Shortcut tab.
  3. Add the feature flag at the end of the Target field, after the double quotes, as follows:

    "C:\Program Files\Tableau\Tableau 10.4\bin\tableau.exe" -DEnableMDXCalcSliceFiltering

  4. Click OK.

For Tableau Server:
On the computer running Tableau Server, open a command prompt as an administrator. 
Navigate to the Tableau Server bin folder and run the following commands: tabadmin stop 
tabadmin set vizqlserver.EnableMDXCalcSliceFiltering true 
tabadmin config 
tabadmin start 

Note: To disable this feature flag on Tableau Server, use the following command: tabadmin set vizqlserver.EnableMDXCalcSliceFiltering -d
 

Cause

Currently the sort order of rows in the view is the same as the automatic grand total. By design calculated members are not included in the grand total.
Did this article resolve the issue?