cancel
Showing results for
Did you mean: Helper II

## How do I Calculate % of users that have "Acquired" all three courses

Hello,

I have a report that includes three different courses. I want to calculate the percentage of users that have completed all three.

Do I have to create a new column or is this just a new measure?

These are the first few columns that include the user data. and I want to check the "Curriculum Status" column to see if each user has Acquired all three. 1 ACCEPTED SOLUTION Community Support

Hi @bcbuckley13 , ``````Measure1 =
CALCULATE(
COUNT(Sheet3[Curriculum Status]),
FILTER(
ALL(Sheet3),
Sheet3[Name] = MAX(Sheet3[Name]) && Sheet3[Curriculum Status] = "Acquired"
)
)``````
``````Measure2 =
VAR y =
CALCULATE(
DISTINCTCOUNT(Sheet3[Name]),
FILTER(
Sheet3,
[Measure1]= 3
)
)
VAR z =
CALCULATE(
DISTINCTCOUNT(Sheet3[Name]),
ALL(Sheet3)
)
RETURN
DIVIDE(
y, z
)`````` Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3 Super User IV

@bcbuckley13 , not very clear do not see any user id, This will give the users who has required all three Curriculum

countx(filter(summarize(Table,Table[user],"_1" ,distinctcount([Curriculum ]),"_1" ,calculate(distinctcount([Curriculum ]), Table[Curriculum Status] ="Acquired")), [_1]=3 && [_1]=[_2]),[user])

Proud to be a Super User! Helper II

I think I'm close, but still can't get it.

Percent All 3 Complete = countx(filter(summarize('In-role Training Completions (BCM, Food Safety, Contactless)','In-role Training Completions (BCM, Food Safety, Contactless)'[GPN],"GPN" ,
distinctcount([Curriculum]),"Contactless Service PH US" ,calculate(distinctcount([Curriculum]), "2020 Food Safety for Team Member, 'In-role Training Completions (BCM, Food Safety, Contactless)[Curriculum Status] ="Acquired")),
[]=3 && [_1]=[_2]),[user])

 Person Organization Name Store ID Name Username GPN Job Role Curriculum Assigned On Acquired On Curriculum Status Community Support

Hi @bcbuckley13 , ``````Measure1 =
CALCULATE(
COUNT(Sheet3[Curriculum Status]),
FILTER(
ALL(Sheet3),
Sheet3[Name] = MAX(Sheet3[Name]) && Sheet3[Curriculum Status] = "Acquired"
)
)``````
``````Measure2 =
VAR y =
CALCULATE(
DISTINCTCOUNT(Sheet3[Name]),
FILTER(
Sheet3,
[Measure1]= 3
)
)
VAR z =
CALCULATE(
DISTINCTCOUNT(Sheet3[Name]),
ALL(Sheet3)
)
RETURN
DIVIDE(
y, z
)`````` Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.  