Power BI Desktop

[marru1982]

Hi All,

Need help to dynamically concatenatex the below scenerio, based on the slicer i.e If a use column2 as a slicer and selected "Bike " then my Concat Column should show only Bike against AAA, 

Note:- Currently able to concat it , but need solution for dynamic concat , 

Column1	Column2	Concat
AAA	Bike	Bike,Car,SUV
AAA	Car	Bike,Car,SUV
AAA	Suv	Bike,Car,SUV
BBB	Boat	Boat,Ship
BBB	Ship	Boat,Ship
CCC	Aeroplane	Aeroplane,Drone
CCC	Drone	Aeroplane,Drone

Thanks

[eliasayyy]

Hello @marru1982 

Measure 2 = 
IF(
    ISFILTERED('Table (2)'[Column2]),
    VAR items = VALUES('Table (2)'[Column2])
    VAR combine = CONCATENATEX(items,'Table (2)'[Column2],"-")
    RETURN
    combine)

if i helped you please accept as solution and levaes a thumbs up

[marru1982]

Thanks , @eliasayyy , I tried the measure , but the concat is not working as expected , all the parameters/column name is same Measure = IF( ISFILTERED('Table (2)'[Column2]), VAR items = VALUES('Table (2)'[Column2]) VAR combine = CONCATENATEX(items,'Table (2)'[Column2],"-") RETURN combine)

The Concat needs to work with both Column1 and column2 present in table , but currently the concat works when i place colum1 and measure , rather column1, column2 and measure

Thanks

[eliasayyy]

can you please share the error or your results

[marru1982]

Sorry currently there is no error , but concat should work , if i have , both column 1 and column 2 and measure rather than only column1

Thanks

[eliasayyy · Accepted solution]

ok please try 

Measure = 
VAR currentColumn1 = SELECTEDVALUE('Table'[Column1])
VAR selectedItems = ALLSELECTED('Table'[Column2])
VAR filteredItems = CALCULATETABLE(
    VALUES('Table'[Column2]),
    'Table'[Column1] = currentColumn1,
    'Table'[Column2] IN selectedItems
)
VAR combine = CONCATENATEX(filteredItems, 'Table'[Column2], "-")
RETURN
combine