Combining multiple column values ( multiple rows) into single column values (single row)

[Thevarupan]

Combining multiple column values ( multiple rows) into single column values (single row) for SPECIFIC values only. 

I have developed a line chart with multiple fruit category (for example). The current table looks like this. 

but as per business new requirement, we need to combine/group  fruit into certain categories. So that when they click the filter link the line chart the values shows the combination of different values. Something like below. 

It doesnt matter if we can do it in the table or even in dax.. but user should be able to select Fruit2 Filter in the front end and the value should show as per the value2 above.

[Thevarupan]

hi @Anonymous , your solution is possible if table 2 exist. But in this case table 2 does not exist ( just an expected outcome). 

Assuming i have this table in PBI, and i need an outcome so that in so called fruit2 column have combination of multiple fruits and also single fruits.

[Anonymous]

Hi @Thevarupan ,

So on what logic do you merge fruit2, please show your sample data and expected results.

Best regards,
Community Support Team_ Scott Chang

[Anonymous]

Hi @Thevarupan ,

I guess you want to filter the fruits by fruit2. you can check the result below:

Measure = var _s = SELECTEDVALUE('Table 2'[Fruit2])
RETURN IF(CONTAINSSTRING(_s,MAX('Table'[Fruit])),1,0)

Please feel free to correct me and provide more information if I have misunderstood you!

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.