Forum Discussion

bryannvpwarrant's avatar
bryannvpwarrant
Frequent Visitor
4 years ago
Solved

Switch statement not giving total

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's avatar
    Whitewater100
    4 years ago

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

3 Replies

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

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