Forum Discussion

Juma1231's avatar
Juma1231
Frequent Visitor
4 years ago
Solved

Count Total Number of Enrollers by Module

Hi All,

I'm new to Power BI and I will be much appreciated if you could help me with the below: 

I'm trying to create a measure to find the total number of enrollers by Module regarless of how many Learning Activity they have done. Sample data below : 

 

IDNameModuleLearning Activity
1211John A.Workplace Safety Manual Handling
1211John A.Strategic PlanningStrategic Leadership
1654Mathew L.Workplace SafetyManual Handling
1654Mathew L.Emotional Intelligence EI Essentials 
1654Mathew L.Emotional Intelligence EI advanced
1439Maria D.Strategic PlanningStrategic Leadership
1439Maria D.Strategic PlanningBusiness Strategy 
1439Maria D.Emotional IntelligenceEI Essentials 

 

Result I'm Looking for:

Total Number of Enrollers for all Modules = 6 ( since one person might enroll to more than one module)

 

Thanks!

I have tried using calculate but I'm not able to overcome how to account repeated modules once per ID/Name. 

  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Juma1231 

     

    Try this:

    Measure = 
Var _A = SUMMARIZE('Table','Table'[ID],'Table'[Name],'Table'[Module])
return
COUNTROWS(_A)

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

4 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi Juma1231 

     

    Try this:

    Measure = 
Var _A = SUMMARIZE('Table','Table'[ID],'Table'[Name],'Table'[Module])
return
COUNTROWS(_A)

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

  • Juma1231's avatar
    Juma1231
    Frequent Visitor
    4 years ago

    Thank you VahidDM @! this is what I was looking for! What if I would like to break the enrollment by completion Status as below : 

     

    IDNameModuleLearning ActivityModule Status
    1211John A.Workplace Safety Manual HandlingComplete
    1211John A.Strategic PlanningStrategic LeadershipIncomplete
    1654Mathew L.Workplace SafetyManual HandlingComplete
    1654Mathew L.Emotional Intelligence EI Essentials Complete
    1654Mathew L.Emotional Intelligence EI advancedComplete
    1439Maria D.Strategic PlanningStrategic LeadershipIncomplete
    1439Maria D.Strategic PlanningBusiness Strategy Incomplete
    1439Maria D.Emotional IntelligenceEI Essentials Complete

     

    so out of the 6 enrollments I should show :

    Completed Modules: 4

    Incomplete Modules: 2

     

    Thanks Again!

    • PaulOlding's avatar
      PaulOlding
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Hi Juma1231 

      You don't need a new measure for that.  Use VahidDM's measure in a table (or other visual) with Module Status

       

      • Juma1231's avatar
        Juma1231
        Frequent Visitor
        4 years ago

        Thank you PaulOlding ! I have used Calculate & filter and have acheived the result I'm looking for.