Forum Discussion

marru1982's avatar
marru1982
Frequent Visitor
3 years ago
Solved

Power BI Desktop

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,  ...
Need Help
Tips and Tricks
  • eliasayyy's avatar
    eliasayyy
    3 years ago

    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

     

     

marru1982's avatar
marru1982
Frequent Visitor
3 years ago

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's avatar
eliasayyy
Memorable Member
3 years ago

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