topic Re: Switch statement not giving total in DAX Commands and Tips

Switch statement not giving total

bryannvpwarrant — Sat, 09 Apr 2022 11:16:24 GMT

Hello - I have a switch statement for my customers based on total sales for example if they meet $20k in sales they get commission of 3k. So I wrote a switch statement see below. Everything looks good but it doesnt total in the table and when I tried to enter sumx in the switch statement I get error please assist.

"

Payout = SWITCH(

TRUE(),

Contract_Header[Total Sales] <= 19999 && Contract_Header[Total Sales] >= 0, VALUE( "0 ") ,

Contract_Header[Total Sales] <= 39999 && Contract_Header[Total Sales] >= 20000, VALUE( "3000 ") ,

Contract_Header[Total Sales] <= 99999 && Contract_Header[Total Sales] >= 40000, VALUE( " 6000 "),

Contract_Header[Total Sales] <= 999999 && Contract_Header[Total Sales] >= 100000, VALUE( " 7500 "))"

Re: Switch statement not giving total

Whitewater100 — Sat, 09 Apr 2022 13:47:39 GMT

Hi:

I can't see what your column is associated with the results. If it is customer and your table column in this visual is Customer[Name] you should be able to do a measure:

Fix Total = SUMX(VALUES(Customer[Name]), [Payout]))

I hope this solves your question..

Re: Switch statement not giving total

bryannvpwarrant — Sat, 09 Apr 2022 14:58:58 GMT

Thank you that worked!!!

Re: Switch statement not giving total

Whitewater100 — Sat, 09 Apr 2022 20:59:13 GMT

Great! Your welcome..