Aggr Count

[Zain2013]

Hi,

need Aggr count based on Br code in the place of one, object name need Aggr count based on br code.

thanks in advance

Regards,

Zain.

[Anil_Babu_Samineni]

Expected result?

[Zain2013]

>20               22

<0                  11

>0 - <10       12

>10 - <20     5

[Anil_Babu_Samineni]

You can simply define as below in measure?

Count(DISTINCT [Br Code])

[Zain2013 · Accepted solution]

applied but not working, you can also find in the application as same.

[jonathandienst]

Count(Distinct [Br Code]) seems to work just fine.

[Zain2013 · Accepted solution]

expression is not working in my application, kindly share the application.

Regards,
Zain.

[Zain2013]

done, I made mistake is no space between distinct and brcode.
have got the requried result.

Thanks,

Regards,

Zain