Forum Discussion

sunilbeckham's avatar
sunilbeckham
Icon for Helper I rankHelper I
3 years ago
Solved

Changing measure calculation based on Column values.

Hello everyone   I have a student table similar to the below dummy columns that I'm trying to create a measure for. I'm trying to create a measure that will change it's calculation depending on the...
  • onurbmiguel_'s avatar
    3 years ago

    hi sunilbeckham 

    Try this measure: 

    VAR _compl_year = SELECTEDVALUE( Student[Completion Years] )
    VAR _value =
        SWITCH(
            TRUE( ),
            _compl_year = "3 Years",
                DIVIDE(
                    CALCULATE( COUNTA( Student[Student Number] ), Student[Graduation Status] = "OT", Student[Source] = "On Time" ),
                    CALCULATE( COUNTA( Student[Student Number] ), Student[Graduation Status] = "OT", Student[Source] = "On Time" )
                ),
            _compl_year IN { "4 Years", "5 Years" },
                DIVIDE(
                    CALCULATE(
                        COUNTA( Student[Student Number] ),
                        Student[Graduation Status] IN { "OT", "ET" },
                        Student[Source] = "Extended Time"
                    ),
                    CALCULATE(
                        COUNTA( Student[Student Number] ),
                        Student[Graduation Status] IN { "OT", "ET" },
                        Student[Source] = "Extended Time"
                    )
                ),
            BLANK( )
        )
    RETURN
        _value

     

     

    Best regards

    Bruno Costa | Power Participant

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍


    You can also check out BI4ALL's website and our data solutions!