Switch statement not giving total

[bryannvpwarrant]

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 "))"

[Whitewater100 · Accepted solution]

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

[bryannvpwarrant]

Thank you that worked!!! 

[Whitewater100]

Great! Your welcome..