Counting # of Completions of training and then displaying

[markhooten]

Hello!

I have a data source that includes completions of up to 3 historical training topics by unique user ID.  I need my report to display only those folks who have completed all three.  For the Excel version of the report I used a COUNTIF and then only displayed those UserIDs that had a "3" in the results.  I'm not sure that will work with PowerBI, or what the best way is to achieve the goal.  

The report will show a total percentage of completion using stacked bars to indicate the number of staff who have completed all three of the historical items, or any one of the current items.

Example:

[Anonymous]

Hi @markhooten 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @markhooten 

COUNTIF function in Excel is to count the data in range. I think your code in Excel is like 

= COUNTIF(B2:B6,"3")/COUNT(A2:A6)

My Sample:

In Power BI try measures as below.

Measure = Divide(calculate(count(Table[ID],Filter(all(Table),Table[Result] =3)),Countax(All(Table),Table[ID])

If this reply still couldn't help you solve your problem, please share a sample with me by your Onedrive for Business. And I am confused about Alt1, Alt2, Current,Historical training in your Legend. I need to know more details about your calculate logic. 

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[parry2k]

@markhooten it will be easier if you can share sample pbix file with the expected output.