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

Thank you for the quick response. I used the statement and only have to change the table name but I get the error message below:

Pass Rate = COUNTROWS('By Program')
VAR Pass Count = CALCULATE(COUNTROWS('By Program'), FILTER('By Program', [Grade] IN {"A", "B", "C", "P"}))

Return Pass Rate/[Pass Count]

 

 

However, I decided to create two separate measures, one that adds pass grades:

Pass Count = CALCULATE(COUNTROWS('By Program'),FILTER('By Program', [Grade] IN {"A", "B", "C", "P"}))

and another that adds all grades: All Grades = COUNTROWS('By Program'), then do Pass Count/All Grades to get my desired results. 

What are my doing wrong in  the error message in order to have all three measures into one? 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

Looks like your VAR name contains a spcae which is not alowed.

Pass Rate --> Pass_Rate

Pass Count --> Pass_Count

etc.

 

Thanks!
A