# How to create a calculated measure in AS 2008 that counts customers with sales amount > 150?

Dear Experts,
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?
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
How about you make a named set of customers like this, and then you could count how many of those appear in just about any other dimension?

Rob
0
Author Commented:
Hi Rob,
please excuse my delay, i was offline for a few days.
Yes, I can build a named set like this:
CREATE DYNAMIC SET CURRENTCUBE.[Kunden mit Listpreis 150 EUR]
AS Filter([Customer].[ID].[ID].members, [Measures].[Sales amount] >= 150), DISPLAY_FOLDER = 'Sets'  ;
But I need a measure, explicitely for Excel, where Sets cannot fuction as report filters in Pivot tables. I also need a measure, so I can use this value in my already existing reports.
There must be a way...
0
Commented:
Once you have your set, can you make a measure based on it?

Rob
0
Author Commented:
How would it look like, then?

0
Commented:

([Kunden mit Listpreis 150 EUR], [Measures].[Customer Count])

Rob
0

Experts Exchange Solution brought to you by