Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Don't worry, I've fixed it. Spaces in the search term!!!!!
Don't worry, I've fixed it. Spaces in the search term!!!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |