在SSAS中，如何在不同的计数度量中删除空值 [英] IN SSAS how to remove null value in distinct count measures

问题描述

我在fact table中有一列.某行中的列具有'Null'值.我在aggregate function设置为DistinctCount

I have column in fact table .the column in some row has 'Null' value.i have measure based on this column with aggregate function Set to DistinctCount

此度量值计数null的值也是如此. 但我不想计算null值我该怎么办?

this measure count null value too. but i don't want to count null value what should i do?

推荐答案

最有效的方法是在数据源视图中过滤出NULL值(例如，使用命名查询).无论如何，这不会对性能产生太大影响，因为无论如何在单独的度量值组中计算出不同的计数度量值.

Most efficient would be to filter out NULL values in the data source view (using a named query for example). This won't affect performance too much as a distinct count measure is calculated in a separate measure group anyway.

这篇关于在SSAS中，如何在不同的计数度量中删除空值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！