Forum Discussion
drwinny
Helper I
Helper Ichecking 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...
drwinnyHelper I
Helper IJihwan_Kim thank you very much the suggested code does work very well with my test data but it seems to have trouble with my actual data. I have updated my sample data with a few false and not started rows to try and show what's happening.
This is the measure:
Pass All Training Measure =
VAR alltraining =
CALCULATETABLE ( VALUES ( Sheet1[Training Code] ), ALL (Sheet1[Training Name]) )
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"
)
For some reason, people have completed the training twice for different companies and can have different values in the passed field (not assigned, false, true.
Any ideas to solve this extra problem?
Many thanks for taking the time to help me, it's really appreciated
Sean.
drwinnyHelper I
Helper ISorry, the measure is:
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"
)