Create a table out of measure which is dynamic

[snair2283]

Hi

I have a table A which has some segments. I have a slicer visual added to the report where I select some of the segments.

I want to create a separate table B which has just the segments that were selected in the slicer. This table would be dynamic.

I created a measure in the table A that combines all the segments selected and concatenates them with a comma in between.

I want to create the table B which 

1. First takes the measure I created 

2. And then transpose them so that each segment is a row by itself.

Please advise

[DataNinja777 · Accepted solution]

Hi @snair2283 ,

As @Greg_Deckler mentioned, a calculated table in the data model cannot dynamically respond to slicer selections. However, you can simulate the visual effect of the ConcatenateX result displaying in rows instead of horizontally concatenated text by using a measure like the one shown below:

SelectedSegments with line break = CONCATENATEX(VALUES(TableA[Segment]), TableA[Segment], UNICHAR(10))

The resulting output is shown below. Please note that when exporting this to a csv file, it will be displayed in a single cell rather than split into four separate rows, which may not meet your requirements.

I have attached an example pbix file for your reference.

[Greg_Deckler]

@snair2283 That's not really possible if I understand what you are trying to do. The only way to sort of do it is to use TOCSV. DAX tables are calculated at the time of refresh and thus are not dynamic.