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

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

  • bryannvpwarrant's avatar
    bryannvpwarrant
    Frequent Visitor
    4 years ago

    Thank you that worked!!! 

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

      Great! Your welcome..