DISTINCT COUNT Where Value > 0

[Rob999]

Hi Everyone.

I need to add a calculated measure to my cube file for the number of occurrences of a transaction type based on a key field. If the transaction occurred, there will be a 4 to 5 digit ID, else a 0.

The problem is when I do a Distinct Count by adding a new measure, I can't put a WHERE criteria on it. Clearly I need to add a Calculated Measure via MDX in the cube. Is there an easy way to do this via MDX?

I'm want to create a Distinct EventCount based on non 0 ID numbers in the EventID column.

Thanks!!!