topic Re: IF Case Not Working in DAX Commands and Tips

IF Case Not Working

Aazam — Thu, 17 Aug 2023 08:39:18 GMT

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

Re: IF Case Not Working

Jihwan_Kim — Thu, 17 Aug 2023 09:42:11 GMT

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