Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculated Measure Multiple Criteria?

Hello Community,   In the table below, I'd like to count the user only if all of their required courses have been completed. The user is assigned to an allotment of courses, but I only want to coun...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

1. The formula evaluates completions while the [Course Completion Status] is "In Progress". It should be "Completed".

Actual User Completions =
CALCULATE (
    DISTINCTCOUNT ( LearningPlanDetails[Username] ),
    LearningPlanDetails[Course Type] = "Online Course",
    LearningPlanDetails[Optional/Required] = "Required",
    LearningPlanDetails[Course Completion Status] = "In Progress"
)

2. I guess we only can say one course of one user is completed. So we need to specify the course name in the formula or in a slicer. 

 

Best Regards!

Dale