Forum Discussion
Changing measure calculation based on Column values.
- 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 _valueBest 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!
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!
- sunilbeckham3 years ago
Helper I
This was really helpful.
Thank you so much for your time and input.