Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
ID | Name | Module | Learning Activity |
1211 | John A. | Workplace Safety | Manual Handling |
1211 | John A. | Strategic Planning | Strategic Leadership |
1654 | Mathew L. | Workplace Safety | Manual Handling |
1654 | Mathew L. | Emotional Intelligence | EI Essentials |
1654 | Mathew L. | Emotional Intelligence | EI advanced |
1439 | Maria D. | Strategic Planning | Strategic Leadership |
1439 | Maria D. | Strategic Planning | Business Strategy |
1439 | Maria D. | Emotional Intelligence | EI 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.
Solved! Go to Solution.
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/
Thank you @VahidDM @! this is what I was looking for! What if I would like to break the enrollment by completion Status as below :
ID | Name | Module | Learning Activity | Module Status |
1211 | John A. | Workplace Safety | Manual Handling | Complete |
1211 | John A. | Strategic Planning | Strategic Leadership | Incomplete |
1654 | Mathew L. | Workplace Safety | Manual Handling | Complete |
1654 | Mathew L. | Emotional Intelligence | EI Essentials | Complete |
1654 | Mathew L. | Emotional Intelligence | EI advanced | Complete |
1439 | Maria D. | Strategic Planning | Strategic Leadership | Incomplete |
1439 | Maria D. | Strategic Planning | Business Strategy | Incomplete |
1439 | Maria D. | Emotional Intelligence | EI Essentials | Complete |
so out of the 6 enrollments I should show :
Completed Modules: 4
Incomplete Modules: 2
Thanks Again!
Thank you @PaulOlding ! I have used Calculate & filter and have acheived the result I'm looking for.
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/
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |