Internal Error on Advanced Table Calculation with Action Filter On Cube Data Source

Published: 18 Sep 2017
Last Modified Date: 26 Nov 2019


When connected to MSAS and setting the advanced table calculation settings for INDEX() to include multiple dimensions and a custom sort, and the view is also filtered by an Action Filter, then Tableau Desktop returns an internal error.


  • Tableau Desktop 10.1.0-10.1.11, 10.2.0-10.2.5, 10.3.0-10.3.4 and earlier versions
  • Microsoft SQL Analysis Services (MSAS)


Option 1

Upgrade to Tableau Desktop 10.2.6, 4.10.3, 10.4.1 or later. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

If you are unable to upgrade, please try using RANK() instead of INDEX().


This behavior is related to a known issue (ID: 675088) which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?