- 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

compliance rate
Hello
Please can you help write a measure to calculate compliance rate for each job level from the data below
Regards
Prashanth
Job Level | Training 1 | Training 2 | Training 3 | Training 4 | Training 5 | Training 6 |
1 | Compliant | Compliant | Compliant | |||
2 | Compliant | |||||
3 | Compliant | Compliant | Compliant | |||
4 | Compliant | Compliant | ||||
5 | Compliant | Compliant | ||||
6 | Compliant | |||||
7 | Compliant | Compliant |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Alternatively if it needs to be a measure you could do something like the below, however it's not as dynamic:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
you can do this in power query by transforming the table,
1. Unpivot all the training columns
2. Then group by job level and value - use aggregation count distict rows
3. Pivot the Count column with aggregation sum
4. Rename blank column to Non Compliant
5. Add a custom column to calculate the % of the compliant column against the total of complaint and non complaint columns
6. Change the data type to percentage
If you need the original data structure you could create a copy of the table in power query befroe performing these steps.
I've attached a PBIX file for you to review the steps above.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-07-2025 07:18 AM | |||
05-05-2025 11:24 AM | |||
01-26-2025 08:48 AM | |||
02-10-2025 06:09 AM | |||
11-13-2024 11:01 AM |
User | Count |
---|---|
96 | |
91 | |
52 | |
46 | |
45 |