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 A...
  • 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
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