DAX count and filter problem

[DHB]

U_DIM_LM_USER
USER_ID	Sum of Practice Quiz Submissions
123	2
456	1
789	1
012	1

U_FCT_LM_QUIZ_SUMISSION
USER_ID	QuizType
123	practice_quiz
123	practice_quiz
456	practice_quiz
456	assignment
789	practice_quiz
789	assignment
012	practice_quiz

I’m trying to create a column (Sum of Practice Quiz Submission) in a table (U_DIM_LM_USER ) which will look up a common value (USER_ID) in another table (U_FCT_LM_QUIZ_SUMISSION) and return a count of a specific value (practice_quiz) from another column in that table.  The result will lopk like the above.

I’ve used this DAX formula, which Power BI doesn’t flag up any errors with, but I don’t get any numbers in my Sum of Practice Quiz Submissions column.

Practice Quiz Submissions = CALCULATE(COUNTROWS ( U_FCT_LM_QUIZ_SUBMISSION ), U_FCT_LM_QUIZ_SUBMISSION[QuizType] = " practice_quiz ",FILTER(ALL(U_FCT_LM_QUIZ_SUBMISSION),U_FCT_LM_QUIZ_SUBMISSION[USER_ID]=U_DIM_LM_USER[User_ID]))

Can anyone see where I’ve gone wrong? Thanks in advance.

[DHB · Accepted solution]

Don't worry, I've fixed it.  Spaces in the search term!!!!!