Function SWITCH TRUE doesn't work

[Anonymous]

Hi! 

I need some help.

I use the SWITCH function but with the same number, i don't have the same result and i don't known why. 

SWITCH(
TRUE(),
M <= 100 , "1",
M <=500, "2",
M <=1000, "3",
M <=1500, "4",
M> 1500,"5"
)

I try with IF too but i got the same result : 

IF(
M <= 100 , "1",,
IF(
M <=500, "2",
IF(
M <=1000, "3",
IF(
M <=1500, "4",
IF(
M> 1500,"5"
)
)
)
)
)

For the first line M = 1170,58 but the result is 4 and the second line M = 1170,40 but the result is 3. 

I really don't understand why it doesn't work. 

[amitchandak]

@Anonymous ,Both seems fine, If you are using a measure this should work fine as measure and if you using a column (M) this work fine as new column

SWITCH(
TRUE(),
[M] <= 100 , "1",
[M] <=500, "2",
[M] <=1000, "3",
[M] <=1500, "4",
[M] > 1500,"5"
)

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous · Accepted solution]

Thanks, I found why it doesn't work. 

It's because M was a measure and the M Score was a colomn. When i changed M Score in colomn. It's worked perfectly. 

[Anonymous]

i can't share the data but i can show you some result. 

id	M	Score
1	1175,02	3
2	1174,4	4
3	1159,96	3
4	1159,9	4
5	39,6	1
6	257,3	2
7	520,1	2
8	178,95	1

For calculate M , i use this : 

SUM('Commandes'[CA Marchandise TTC]),

But the switch function doesn't work correctly. 

[amitchandak]

@Anonymous , can check the data type or M, it should be number - Decimal ?

[Anonymous]

the column M is General Number

the column CA Marchandise TTC is devise

and the column Score is Standard