how to get multiple rule to a single column

[oakfootballclub]

Hi experts, recently I have encountered a complicated problem and now hope to be able to solved via your support.

here is the data:

value
5
7
14
16
4
2
8
10
20
3
6

and based on the data above here is a  rule to get a new column

when		then
1<= value < 10		A
6<=value<10		B
value>=10		C

and here is the expected result:

value	expected result
5	A
7	A, B
14	C
16	C
4	A
2	A
8	A, B
10	C
20	C
3	A
6	A, B

can you help me to get the expected result? Thank you.

[elitesmitpatel · Accepted solution]

Here is the solution 

create a measure -->

Category =

var a = IF(SUM('Table'[value]) >= 1 && SUM('Table'[value]) < 10, "A ",BLANK())

var b = IF(SUM('Table'[value]) >= 6 && SUM('Table'[value]) < 10, ", B",BLANK())

var c = IF(SUM('Table'[value]) >= 10, "C", BLANK())

RETURN

CONCATENATE(a,CONCATENATE(b,c))

Here is the file --
Get multiple rule to a single column 

If it helps ,Please appreciate by Accept it as solution.

[dharmendars007 · Accepted solution]

Hello @oakfootballclub , 

Please try this measure in your calculated column, this should work..

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[oakfootballclub]

Hi experts, recently I have encountered a complicated problem and now hope to be able to solved via your support.

here is the data:

value
5
7
14
16
4
2
8
10
20
3
6

and based on the data above here is a  rule to get a new column

when		then
1<= value < 10		A
6<=value<10		B
value>=10		C

and here is the expected result:

value	expected result
5	A
7	A, B
14	C
16	C
4	A
2	A
8	A, B
10	C
20	C
3	A
6	A, B

can you help me to get the expected result? Thank you.

[elitesmitpatel · Accepted solution]

Here is the solution 

create a measure -->

Category =

var a = IF(SUM('Table'[value]) >= 1 && SUM('Table'[value]) < 10, "A ",BLANK())

var b = IF(SUM('Table'[value]) >= 6 && SUM('Table'[value]) < 10, ", B",BLANK())

var c = IF(SUM('Table'[value]) >= 10, "C", BLANK())

RETURN

CONCATENATE(a,CONCATENATE(b,c))

Here is the file --
Get multiple rule to a single column 

If it helps ,Please appreciate by Accept it as solution.