Forum Discussion
Selection measure
Hi,
Need to know where I am going wrong here. This measure is supposed to find users who have passed both of these two trainings within 7 days of enrollment.
Merged.2 = User Completion date
7th of Enrolled date = is the deadline date
Training Name = "2021 Training - Part 1"
"2021 Training - Part 2 (Final Exam)"
Measure
Eligibility =
VAR _1 = 'User Performance'[Pass/fail] = "Passed"
VAR _2 = 'User Performance'[Merged.2] <= 'User Performance'[7th of Enrolled Date]
VAR _2B = 'User Performance'[Training Name] = "2021 Training - Part 1" &&
'User Performance'[Training Name] = "2021 Training - Part 2 (Final Exam)"
VAR _3 = IF ( (_1 && _2 && _2B) = TRUE() , TRUE() , FALSE() )
RETURN
_3
Currently with the measure that I have above this user is showing up on my ELIGIBLE list even if she was late with PART 2...to be specific the view is showing PART1 but she is not eligible as she mssed the deadline for part 2. Basically they should show up on the view only if they passed both the exams with the given date range.
Currently this is how it shows on the view
| Last | First | Training Name | Enrollment | Merged | 7th of Enrolled Date | pass/fail |
| A | B | 2021 Security Training - Part 1 | 11/9/2021 | 11/9/2021 | 11/16/2021 | Passed |
Can someone please advise? Thank you!!
1 Reply
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
