Show value conditionally

[#1]

Hi,

I have a requirement to show Employee cost only if the number of employees in that project are higher than 5.

It is posible to find the distinct employee count but need help to find the distinct employee count in project?

if(Count( distinct EmployeeId)>5,$(CostOwn),0)

Thanks in advance,

Rahul

[#2 · Accepted solution]

i have found one expression as below but it's still under testing.

=sum (aggr(if(Count(distinct EmployeeId)>5,$(CostOwn) ,0),ProjectId))

[Nicole-Smith]

To find a count in a project, there are two ways you could do it:

1.  If Project is one of your dimensions, it will automatically find the count for just that project.

2.  Use aggr() around your count function with Project as the dimension:  aggr(Count(distinct EmployeeId), Project)