Variables using Switch True

[Anonymous]

Hi, 

I would like to make variables on sales using the North Wind database. But when trying to use the Var_salg column all of my products are placed in group "D: Over 10000"

Var_salg =

VAR Val =

SUMX(Order_Details;Order_Details[UnitPrice]*Order_Details[Quantity])

Return

SWITCH(TRUE();

Val <=1000; "A: 0-1000";

Val <=5000; "B: 1001-5000";

Val <=10000; "C: 5001-10000";

Val >10000; "D: Over 10000")

[v-chuncz-msft]

@Anonymous 

It seems that you'll need to add RELATEDTABLE.

[Anonymous]

Hi @v-chuncz-msft 
How do you mean?

[Anonymous · Accepted solution]

It works now. 

I simply created a SUMX measure for "I alt salg":

Var_salg =

VAR Val =

[I alt salg]

Return

SWITCH(TRUE();

Val <=1000; "A: 0-1000";

Val <=5000; "B: 1001-5000";

Val <=10000; "C: 5001-10000";

Val >10000; "D: Over 10000")