Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculated Measure Multiple Criteria?

Hello Community,   In the table below, I'd like to count the user only if all of their required courses have been completed. The user is assigned to an allotment of courses, but I only want to coun...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

=COUNTROWS(FILTER(SUMMARISE(VALUES(LearningPlanDetails{UserName]),[UserName],"ABCD",CALCULATE(COUNTROWS(LearningPlanDetails),LearningPlanDetails[Course Completino Status]="Completed")),[ABCD]=COUNTROWS(LearningPlanDetails)))

 

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Ashish_Mathur & v-jiascu-msft - Thank you for your assistance!

     

    Ashish, I tried your solution but did not get it to work.

     

    Dale, I appreciate your reply but it came off a bit too cryptic for me so I didn't understand it.

     

    That said, I was able to figure out how to get my desired result and it works too good lol. I adjusted the calculated measure the now subtract the incomplete and in progress statuses from the completed statuses in order to get a count of the usernames who only have completed all of their required courses. My issue now is that if there is more than one class that is incomplete or in progress, the count goes below 0 to either -1 or -2. My fear is that these negative numbers are affecting the overall sum of users who have actually completed their training. Is it possible to have the number display as 0 instead of a negative number?

    Updated Calculated Measure Logic

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi Anonymous,

       

      Share the link from where i can download your file.