How to create a calculated measure in AS 2008 that counts customers with sales amount > 150?
Posted on 2009-07-06
in AS 2008 I try to figure out, how to create a calculated measure that counts customers with sales amount > 150 ¬ over all dimensions (Time, Product, Customer Hierarchies etc.). I created a cube measure with DISTINCT COUNT on Customer ID in fact table. This measure counts all customers who appear in the Sales Fact table (counts buying costumers).
I tried Count(Filter([Customer].[ID].[ID], [Measures].[Sales Amount] > 150)), but it does not work in any dimension, when browsing the cube.
Can anybody help?