Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Academic course pass rate

Hello every one, I am new to Power BI because my institution just switched to it recently. I need help creating a measure that calculates course pass rate. This would represent the percent of course...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous 

    Create a measure to retreive pass/total.

    PASS_RATE_M =
VAR TOTAL_COUNT =
    COUNTROWS ( T22 )
VAR PASS_COUNT =
    CALCULATE (
        COUNTROWS ( T22 ),
        FILTER (
            T22,
            T22[Grade]
                IN {
                "A",
                "B",
                "C"
            }
        )
    )
RETURN
    PASS_COUNT / TOTAL_COUNT

     

    Cheers!
    A

Anonymous's avatar
Anonymous
Not applicable
7 years ago

assuming you're choosing all grades as having equal value, then these are really just pass/fail percentages.  I'd create a column from the letter grades, which is a "pass/fail" column.  put your condition of a/b/c there, and make it a pass or fail value. (or a binary column called "pass?" to be even faster)

 

then you can create a measure to calculate pass %.