Forum Discussion

JOSELUISMTZRMZ1's avatar
JOSELUISMTZRMZ1
Icon for Helper I rankHelper I
4 years ago
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 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 😐

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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)

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      JOSELUISMTZRMZ1
      Icon for Helper I rankHelper I
      4 years ago

      Nice try, it works 🙂 

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