Forum Discussion

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

IF Case Not Working

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's avatar
    Jihwan_Kim
    3 years ago

    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

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    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