- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How to show status of the training completion by User Name
key | User | Manager | BI | CD | Tool | PO | DB | Trarining Complete |
1 | Alex | Shane | Y | Y | Y | Y | Y | Y |
2 | Angela | Shane | Y | Y | Y | Y | Y | Y |
3 | Andrew | Shane | Y | Y | Y | Y | N | N |
4 | Jamie | Chris | Y | Y | Y | N | Y | N |
5 | Joseph | Chris | N | N | N | N | N | N |
6 | Smith | Katherine | Y - PASS | Y | Y - PASS | Y | Y | Y |
7 | Bravo | Katherine | Y | Y | Y | Y | Y | Y |
8 | Dean | Lee | Y | Y | Y | Y | Y | Y |
9 | John | Lee | Y | Y | Y | Y | Y | Y |
10 | William | Lee | Y | Y | Y | Y | N | N |
Training Complete Excel formula= =IF(COUNTIF(D2:H2,"")>0,"N",IF(COUNTIF(D2:H2,"N")>0,"N","Y")) for all the rows in Training Complete.
Problem: I like to show in PowerBI the status of the training completion by user name, report should show completion status of training complete and overall % complete. I like to filter on the Manager
Thanks in advance team.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
You could create the calculated columns as below :
- for Training Status :
- For Training Passing Ratio :
Thanks for Kudos,
Please mark it as solution if it helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks,
like to understand a bit more about the UPPER(left(trim(sheet217[BI], as BI I can understand it the the table but the rest of the query..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

SHEET217 ? Is a bit confusing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @DavidGM ,
For this, I would unpivot the data first before making any calculations. Once unpivoted, I can then count the number of N per user and then use the count in calculating for the percentage of completion.
Here are the measures I'd use:
Count of Incomplete =
CALCULATE (
COUNTROWS ( 'Table' ),
FILTER ( ALLEXCEPT ( 'Table', 'Table'[EY #] ), 'Table'[Value] = "N" )
)
Progress % =
1 - DIVIDE ( [Count of Incomplete], 6 )
Training Status =
IF ( [Count of Incomplete] = BLANK (), "Y", "N" )
Sample result:
Please see attached pbix for the details.
Dane Belarmino | Microsoft MVP | Proud to be a Super User!
Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It worked well for me! Thanks

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-30-2024 10:24 PM | |||
04-25-2024 10:06 AM | |||
04-29-2024 01:03 AM | |||
09-05-2024 07:46 PM | |||
Anonymous
| 10-24-2019 06:05 AM |
User | Count |
---|---|
121 | |
102 | |
88 | |
52 | |
46 |