Counting distinct data from FACT table returns correct numbers but SSAS cube does not

Josip Horacek 0 Reputation points
2023-10-27T08:01:12.6933333+00:00

Hi,

I have a problem with distinct count measures in SSAS cube. When I check my FACT table numbers - they are correct but distinct count measure (in combination with location data) in a cube shows different numbers. When I do not combine location data, numbers in a cube are correct. Dimension and fact table have correct joins and everything seems ok.

When I count data of parcels by the location dimension - I get higher and incorrect numbers than the numbers that should be returned. Tried few options through Visual studio, but data in the cube still showing incorrect numbers.

Data from the FACT table:

User's image

Data from the cube:

User's image

Any ideas?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,217 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
{count} votes