Hi All Please can you help to calculate JL wise Pass rate for the data shared below for each Program name. Job BandPass/FailProgram Name2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2FailFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassIntermdiate2PassIntermdiate2PassIntermdiate2PassIntermdiate2PassIntermdiate2PassIntermdiate2PassIntermdiate2FailIntermdiate2PassIntermdiate2PassIntermdiate2PassIntermdiate2PassIntermdiate2PassIntermdiate2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2FailFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassFoundation2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2FailProfessional2PassProfessional2FailProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2PassProfessional2FailProfessional2PassProfessional2PassProfessional2PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4FailFoundation4PassFoundation4PassFoundation4PassFoundation4PassFoundation4PassFoundation4FailFoundation4PassFoundation4PassFoundation4PassFoundation4PassProfessional4PassProfessional4PassProfessional4FailProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional4PassProfessional3FailProfessional3PassProfessional3PassProfessional3PassProfessional3PassProfessional3PassProfessional3PassProfessional3PassProfessional3FailProfessional3PassProfessional3PassProfessional3PassPro 13PassPro 13PassPro 13FailPro 13FailPro 13PassPro 13PassPro 13PassPro 1

Hi, try this: Measure = CALCULATE(COUNT('Table'[Pass/Fail]),'Table'[Pass/Fail]="Pass",ALLEXCEPT('Table','Table'[Program Name]))/CALCULATE(COUNT('Table'[Pass/Fail]),ALLEXCEPT('Table','Table'[Program Name])) If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Hello I applied the logic to actual data set and for some reason the numbers are not accurate. The results are going beyond 100% The actual numbers should be this, But the PowerBI Logic is giving below numbers Below is the DAXi have used JL Wise Completion Rate = CALCULATE(COUNT('Training Details Fy 22'[Pass/Fail_1]),'Training Details Fy 22'[Pass/Fail_1]="Pass",ALLEXCEPT('Training Details Fy 22','Training Details Fy 22'[Program Name]))/CALCULATE(COUNT('Training Details Fy 22'[Pass/Fail_1]),ALLEXCEPT('Training Details Fy 22','Training Details Fy 22'[Program Name])) Please advice

Ah okay, i wasn't aware that the job band would also be used, you can just adapt the allexcept criteria to use the job band column too. try removing the all except criteria: JL Wise Completion Rate = CALCULATE(COUNT('Training Details Fy 22'[Pass/Fail_1]),'Training Details Fy 22'[Pass/Fail_1]="Pass")/CALCULATE(COUNT('Training Details Fy 22'[Pass/Fail_1])) If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Hello I tried using the same DAX and still not givig the desired results

shantupm5

Helper III

2 years ago

Pass Rate

Hi All

Please can you help to calculate JL wise Pass rate for the data shared below for each Program name.

Job Band	Pass/Fail	Program Name
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Fail	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Fail	Intermdiate
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Pass	Intermdiate
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Fail	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Foundation
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Fail	Professional
2	Pass	Professional
2	Fail	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
2	Fail	Professional
2	Pass	Professional
2	Pass	Professional
2	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Fail	Foundation
4	Pass	Foundation
4	Pass	Foundation
4	Pass	Foundation
4	Pass	Foundation
4	Pass	Foundation
4	Fail	Foundation
4	Pass	Foundation
4	Pass	Foundation
4	Pass	Foundation
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Fail	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
4	Pass	Professional
3	Fail	Professional
3	Pass	Professional
3	Pass	Professional
3	Pass	Professional
3	Pass	Professional
3	Pass	Professional
3	Pass	Professional
3	Pass	Professional
3	Fail	Professional
3	Pass	Professional
3	Pass	Professional
3	Pass	Pro 1
3	Pass	Pro 1
3	Pass	Pro 1
3	Fail	Pro 1
3	Fail	Pro 1
3	Pass	Pro 1
3	Pass	Pro 1
3	Pass	Pro 1

Need Help

Show and Tell

Tips and Tricks

9 Replies

DOLEARY85
Resident Rockstar
2 years ago
Hi,

try this:

Measure = CALCULATE(COUNT('Table'[Pass/Fail]),'Table'[Pass/Fail]="Pass",ALLEXCEPT('Table','Table'[Program Name]))/CALCULATE(COUNT('Table'[Pass/Fail]),ALLEXCEPT('Table','Table'[Program Name]))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- shantupm5
  Helper III
  2 years ago
  Hello
  
  I applied the logic to actual data set and for some reason the numbers are not accurate. The results are going beyond 100%
  
  The actual numbers should be this,
  
  But the PowerBI Logic is giving below numbers
  
  Below is the DAXi have used
  
  JL Wise Completion Rate = CALCULATE(COUNT('Training Details Fy 22'[Pass/Fail_1]),'Training Details Fy 22'[Pass/Fail_1]="Pass",ALLEXCEPT('Training Details Fy 22','Training Details Fy 22'[Program Name]))/CALCULATE(COUNT('Training Details Fy 22'[Pass/Fail_1]),ALLEXCEPT('Training Details Fy 22','Training Details Fy 22'[Program Name]))
  
  Please advice
  - DOLEARY85
    Resident Rockstar
    2 years ago
    Ah okay, i wasn't aware that the job band would also be used, you can just adapt the allexcept criteria to use the job band column too.
    
    try removing the all except criteria:
    
    JL Wise Completion Rate = CALCULATE(COUNT('Training Details Fy 22'[Pass/Fail_1]),'Training Details Fy 22'[Pass/Fail_1]="Pass")/CALCULATE(COUNT('Training Details Fy 22'[Pass/Fail_1]))
    
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Ahmedx
Super User
2 years ago
pls try

64.pbix19 KB

Forum Discussion

Pass Rate

9 Replies

Related content

Utilization Rate

Currency FX Rates

Adding an intererst rate

Fabric passing parameter

Pass/fail rate for groups across time