How to generate a list of values from a column based on a filter useing another column

[Anonymous]

Hi all,

I have a table with two columns, first column is type (A,B,C,...) and second column is some textual values .

Type	Code
A	ab
A	bc
B	de
C	ef
B	hj
A	lk

I a need a DAX formual to return all values from "Code" column based on a filter for type column. Then I will use this DAX to populate rows of a Matrix visual.

for exmaple I need all codes that are type A . Results (ab,bc,lk).

[amitchandak]

@Anonymous , use concatenatex

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax

new measure

concatenatex(Table, Table[Code])

display with Type

[Anonymous]

@amitchandak, Sorry I think I wasn't clear in my description of the issue. I don't need to concatinate columns. I need to filter rows in a table and then display values from another column for thise filtered rows.

In my example I want to dispaly all code values that are type A.

[V-pazhen-msft · Accepted solution]

@Anonymous 

Maybe you do not need another column or measure. You can put code in the Colum and Value field.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.