Using a where clause

[bguiliano]

I created a  measure for counting distinct members..this seems to work

aggr(count(distinct member_key),source_provider_name)

However, if i wanted to add a where clause to it, how would it look...

I tired 'aggr(count(distinct member_key),source_provider_name) where[source_provider_name] = 'SPECIFIC PROVIDER NAME' 

It did not seem to like it.

Thanks in advance...

[alexpanjhc]

try

aggr(count({<[source_provider_name]={'SPECIFIC PROVIDER NAME'}>}distinct member_key),source_provider_name)