Count in Dimension

[tracycrown]

Dear all

Can someone help to explain why count function for "No. of Employee" not work in Dimension ?.

Thank you very much

Tracy

[MarcoWedel]

Maybe the aggr() function helps

[mdmukramali · Accepted solution]

Dear Tracy,

Use below code in dimension

=Aggr(count(Emp_No),Company)

Thanks,

Mukram

[ecolomer]

Here you have my proposal