Count Total Number of Enrollers by Module

[Juma1231]

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. 

[Juma1231]

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!

[PaulOlding]

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]

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

[VahidDM · Accepted 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/