SSAS distinct count results wrong number.
While querying the table as follow:
SELECT count (distinct USER_ID ) FROM Table
I get this results -- 1033612
While querying SSAS I get 257.
Sample data for USER_ID:
I have also tried to convert this Varchar(100) into checksum()
sample data :
still getting same results.
the measure is located in stand alone measure group. and configured with default settings.