FIX: An MDX query returns incorrect results in SSAS 2014 or 2016 Tabular mode

Applies to: SQL Server 2014 Service Pack 2SQL Server 2014 DeveloperSQL Server 2014 Enterprise

Symptoms


Assume that you use Microsoft SQL Server 2014 Analysis Services (SSAS 2014) in Tabular mode. When you execute a query that uses a Distinct Count calculation, values may be missing from the query result.

 

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.