Count distinct

Hi guys,

This question might seem a bit stupid to you. I have a fact table representing financial transactions. One of the dimensions is the card number. I need to count the number of distinct cards that made transactions for a given period and a given store. I want to create a calculated member, but I have no idea how to do it. Can you give me any help?

Thanks

Felipe

Don't know if I'm seeing the "whole picture".

Can't you just creat a measure group linked to the card_number and select countdistinct as the aggregated function?

Thanks, I'll try this.

It was SO easy... I've been wrestling with this a day and a half...

I guess it's the price to pay for learning.

glad it was helpfull.

with member [DistCount] as

distinctcount(exists([Company].[Company Name].children,[Measures].[Spend in USD]))
Select {
    [Measures].[DistCount]} on 0

From Cube Name