KNOWLEDGE BASE

Discrete aggregated measure splits the view into multiple rows or columns


Published: 04 Jan 2016
Last Modified Date: 28 Jun 2016

Issue

When using a discrete aggregated measure, the view splits into multiple values as rows or columns.

Environment

Tableau Desktop

Resolution

Create an Exclude LOD expression to exclude the dimensions in the view to produce the desired level of detail.

Cause

Aggregated measures are always by the mark in the view.  This means that changing the view level of detail can drastically affect the values produced by the aggregated calculation.  Notice how adding Month to columns affects the Discrete SUM(Profit) in the following screen shots.

User-added image

Now, add Months to Columns...

User-added image

Tableau Desktop calculates the SUM(Profit for each month.

To resolve this create an LOD expression that excludes Month.  In this example we have to make a dimension for this.

Month
DATENAME('month', [Order Date])

LOD Profit

{ EXCLUDE [Month] : SUM([Profit]) }

Now the view looks like:

User-added image

Did this article resolve the issue?