cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DHB Helper III
Helper III

DAX count and filter problem

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.

1 ACCEPTED SOLUTION

Accepted Solutions
DHB Helper III
Helper III

Re: DAX count and filter problem

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

View solution in original post

1 REPLY 1
DHB Helper III
Helper III

Re: DAX count and filter problem

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

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors