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

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

can you please share the error or your results

  • 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
      Icon for Memorable Member rankMemorable 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