Forum Discussion

drwinny's avatar
drwinny
Icon for Helper I rankHelper I
5 years ago

checking if multiple training modules are complete and mark as completed

Hi All,   I need to check if a user has passed multiple training courses or not and then return yes/no, true/false answer  In the example joe bloggs1 did not complete all the training so that woul...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, drwinny 

Please check the link down below.

 

 

Pass All Training Measure =
VAR alltraining =
CALCULATETABLE ( VALUES ( Sheet1[Training Code] ), ALL ( Sheet1 ) )
VAR currentuserpasstraining =
SUMMARIZE (
FILTER (
ALL ( Sheet1 ),
Sheet1[User Name] = MAX ( Sheet1[User Name] )
&& Sheet1[Passed] = TRUE ()
),
Sheet1[Training Code]
)
RETURN
IF (
COUNTROWS ( alltraining ) <= COUNTROWS ( currentuserpasstraining ),
"YES",
"NO"
)

 

 

https://www.dropbox.com/s/sqipj7ljvhof7ja/Training%20Example.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM