Forum Discussion
Solved
DAX help to count 100% completion
I have a matrix table which shows the training completion rate per region and employee. I have about 8000 employees, each assigned multiple courses to complete. As you can see from the scree...
pls see the attachment below. It will be better if you can provide some dummy data and expected output
I tried to do it myself and it's not working:
Here's my attempt. My addition is shown underlined.
User Completion =
VAR tbl=SUMMARIZE('Training','Training'[COUNTRY],Training[User - User ID],"completed",DIVIDE(CALCULATE(COUNTROWS('Training'),FILTER('Training','Training'[Transcript - Transcript Status]="Completed" || 'Training'[Training - Training Title]<>"MRS - Module 18: Additional Features - August 20220" )),CALCULATE(COUNTROWS('Training'),ALLEXCEPT('Training','Training'[User - User ID]))))
return COUNTROWS(FILTER(tbl,[completed]=1)) +0
maybe you can try this
Measure =
VAR tbl=SUMMARIZE('Table','Table'[Location],'Table'[User ID],"complete",DIVIDE(CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Course Completion status]="Y" && 'Table'[Course Title]<>"ABC123")),CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[User ID]),'Table'[Course Title]<>"ABC123")))
return COUNTROWS(FILTER(tbl,[complete]=1))
pls see the attachment below