Hi, I need to count how many users have completed all courses. They're compliant only if ALL courses have completed, otherwise they're not.This is a data example. In this example, user1 should NOT be compliant, but user 2 should be counted as compliant. I also need to calculate the percentage of compliant users.CourseUserCompletedCourse 1User1YesCourse 2User1NoCourse 3User1YesCourse 4User1NoCourse 1User2YesCourse 2User2YesCourse 3User2YesCourse 4User2YesThanks!

it seems like you figured it out, but the reason you were seeing it return 843, was because it was only counting those who had not completed any courses, Non-compliant users should include those who have completed courses, ie: any user whose number of completed course does not equal the number of courses assigned. [TotalCourses] <> [CompletedCourses]So at the end of the measure instead of an =, you would use <> instead of switching Yes to No

Count only compliant user | Microsoft Fabric Community

Forum Discussion

Related content

Lakehouse supports ACID compliant

Counting nulls

Count Of Drivers

Count of parents for which all the childs are compliant

Count Measure