Forum Discussion
Solved
How to sum per 2 column criterias
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 s...
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)
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)
Nice try, it works 🙂
Thank you for your suggesstion, I was still not able to get it.
