Set Analysis to show Number of Employees that have '3' or more Objectives met

[50ShadesOfSalty]

Hi Everyone,

As the title displays, i'm trying to create one set analysis that retrieves the Number of Employees with 3 or more Objectives met.

If i create a table with the following:

Dimension: Employee Id

Measure: If(Count(DISTINCT [Objectives] >=3, [Account Id]))

I can clearly see how many Employees have 3 or more objectives met.

However i'm having a hard time make it in a set analysis, for example:

Count( Distinct {< [Employee Id]={"=Count(DISTINCT [Objectives] >=3, [Account Id])"} >}[Counter per Employee])

->[Counter per Employee]: This field is filled with the value 1 per Employee Available.

Can someone help me?

Thank you for the help!

[tm_burgers]

The below formula works for me as a KPI:

sum(if(AGGR(count(distinct Objectives),EmployeeID)>=3,1))

[agigliotti · Accepted solution]

maybe this:
=Count( {< [Account Id] ={"=Count(Objectives)>=3"} >} DISTINCT [Account Id] )

I hope it helps.

[Anil_Babu_Samineni]

If you adjust your measure to below // This also kind of set analysis only, And I Don't see any performance over here. Do you?

Count(DISTINCT If(Objectives >=3, [Account Id]))

Or

Simply, Count(DISTINCT {<Objectives ={">=3"}>} [Account Id])

[RsQK]

Hey, try this:

Count({< [Employee Id]={"=Count(DISTINCT [Objectives]) >=3"} >}Distinct[Employee Id])