IF Case Not Working

[Aazam]

Hi,

I am having a problem with my DAX, I tried "switch case" as well but it did not work. I am stuck on this issue.

I want average values but it is printing values in Total Column instead of Average Column

MY DAX:
Var bookings = [No Of Booking] VAR Averages = DIVIDE(bookings, 7, 0) VAR result_print =     IF(         SELECTEDVALUE(Weekdays[WeekDays]) in {"Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun"},         [No Of Booking],Averages     )     RETURN result_print

[Jihwan_Kim · Accepted solution]

Hi, I am not sure how your datamodel looks like, but please try something like below.

expected result measure =
VAR bookings = [No Of Booking]
VAR Averages =
    DIVIDE ( bookings, 7, 0 )
VAR result_print =
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( Weekdays[WeekDays] )
            IN { "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun" }, [No Of Booking],
        SELECTEDVALUE ( Weekdays[WeekDays] ) = "Averages", Averages,
        [No Of Booking]
    )
RETURN
    result_print