How to sum per 2 column criterias

[JOSELUISMTZRMZ1]

Hello Everyone

Please any suggestion how I could do the next

I have a table like my below image where I need to show who one has completed all courses.

Anne has completed all the 3 courses so I will have to show her name, and any user who completes the all 3 courses which means "3points". The visualization I think is a table, if I set the user name only is enough 🙂 

The table has been Transformed and it is used in another visualizations, so DAX is what I'm looking for

Any suggestion how to sum the column POINT 1 per user and status = done?

thank you 😉

PS. I've tried summarizecolumn, groupby but I'm not able to SUM per users and status 😐

[Vera_33 · Accepted solution]

Hi @JOSELUISMTZRMZ1 

In your sample data, JHON has completed 3 courses, too. When it is done there is 1 point, do you need to check the status as well?

TEST = 
VAR TotalCourse=COUNTROWS(VALUES('Table'[COURSE]))
RETURN
IF(SUM('Table'[POINT])=TotalCourse,TotalCourse)

[JOSELUISMTZRMZ1]

Nice try, it works 🙂 

Thank you for your suggesstion, I was still not able to get it.