Aggr function

[TheresaB_4]

Hi everyone, I am trying out my first function. I need some help.

background:
I want to count the Account number(EAN) where the customerStatus is 'Active'

Is this possible if I make this a measure or should I make this a Dimension.

here is my aggr 

=aggr(Count(distinct EAN),<CustomerStatus={'Active'}>)

[justISO]

Hi, try this maybe?: Count({<CustomerStatus={'Active'}>} distinct EAN)

[Aditya_Chitale · Accepted solution]

Why do you want  to use aggr here ? You can write  a simple set analysis expression inside count() function:

count({<CustomerStatus={'Active'}>}distinct EAN).

Aggr is mostly used when you want to perform aggregations on multiple sub-sets of data in a field.

Regards,

Aditya