Counting distinct data from FACT table returns correct numbers but SSAS cube does not
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:
Data from the cube:
Any ideas?