NULL Value Disappears When Adding LOD Calculation

Published: 12 Mar 2018
Last Modified Date: 14 Oct 2019


When connecting to Google Bigquery, creating a view that has a dimension with a NULL value, and then adding a level of detail (LOD) calculation with a level of detail different than the view, then the NULL member disappears


  • Tableau Desktop 10.5.0-10.5.2 or earlier versions
  • Google BigQuery


Option 1

Upgrade to Tableau Desktop 10.5.3. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

Use table functions rather than LOD expressions.


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