If Statement Trouble

[arobinson]

Need help for this to calculate properly. Stops at 4.

Attendance Measure =

If(sum('Monthly Goals'[Attendance Goal]) - sum(Attendance[Unexcused Hours Taken]) = 0,0,

If(sum('Monthly Goals'[Attendance Goal]) - sum(Attendance[Unexcused Hours Taken]) >=1,4,

If(sum('Monthly Goals'[Attendance Goal]) - sum(Attendance[Unexcused Hours Taken]) <=4,4,

If(sum('Monthly Goals'[Attendance Goal]) - sum(Attendance[Unexcused Hours Taken]) >4,8

))))

[HotChilli]

If the value is greater than 4 , it's also greater than 1 so it's already been dealt with.

Also use a variable and a switch statement instead.

[AntrikshSharma]

Try this:

Attendance Measure =
VAR Amount =
    SUM ( 'Monthly Goals'[Attendance Goal] ) - SUM ( Attendance[Unexcused Hours Taken] )
VAR Result =
    IF ( Amount = 0, 0, IF ( Amount >= 1 && Amount <= 4, 4, IF ( Amount > 4, 8 ) ) )
RETURN
    Result

or

Attendance Measure =
VAR Amount =
    SUM ( 'Monthly Goals'[Attendance Goal] ) - SUM ( Attendance[Unexcused Hours Taken] )
VAR Result =
    SWITCH (
        TRUE (),
        Amount = 0, 0,
        Amount >= 1 && Amount <= 4, 4,
        8
    )
RETURN
    Result