We need help with figuring out the proper syntax to use for comparing measure values that fall within a range of values. For example, in the “Faculty Cost (WWReg)” calculated column below, we are wanting the value of 1218 to be returned when all conditions are met. However, even though the formula does not yield an error, it returns as “blank”. It has to do something with the syntax of the whether Registrations is greater than or equal to 2 AND less than or equal to 9.
We’re not able to use a summarized table because the information we need is by the Course within a Program belongs to. The course and the amount of students is what makes up the cost.
Faculty Cost (WWReg) =
‘WW Registrations’[Instructor Available] = “Part-Time” && ‘WW Registrations’[Academic Year End Academic Career] = “Undergraduate” && AND([Registrations] <= 2, [Registrations] >= 9), “1218”)
Here is the “Registrations” measure:
SUM(‘WW Registrations’[Course Registration]), VALUES(‘WW Registrations’[Academic Year]),VALUES(‘WW Registrations’[Academic Year End Academic Plan No Roll-up Description]),VALUES(‘WW Registrations’[Academic Course]))