Forum Discussion
Pass Rate
Hello
I tried using the same DAX and still not givig the desired results
Okay, you could try allexecpt on both program name and job band in case there's something else impacting the measure:
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],'Training Details Fy 22'[Job Band]))/CALCULATE(COUNT('Training Details Fy 22'[Pass/Fail_1]),ALLEXCEPT('Training Details Fy 22','Training Details Fy 22'[Program Name],'Training Details Fy 22'[Job Band]))
if this doesn't work are you able to provide a copy of the PBIX file?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍