mdx - IN SSAS how to remove null value in distinct count measures -
i have column in fact table .the column in row has 'null' value.i have measure based on column aggregate function set distinctcount
this measure count null value too. don't want count null value should do?
most efficient filter out null values in info source view (using named query example). won't impact performance much distinct count measure calculated in separate measure grouping anyway.
ssas mdx
No comments:
Post a Comment