List of values based on the string in another column

[Nun]

Hello,

I have a table with two columns.

Column A  Column ID

France          1A32

Germany      2BBCC

France          354A4

France          66A97

Poland         AA543  

Poland        132VV

I would like to create a DAX formula.

The first one is the list of column ID based on the value of Column A

the result should be that a table visualizazion will show all the values in Colum ID just for France.

Thanks!

[Anonymous · Accepted solution]

Hi @Nun ,

You can use the following DAX to create a measure:

France = 
CALCULATE(
    CONCATENATEX('Table','Table'[ColumnID]," , "),
    'Table'[ColumnA] = "France"
)

And the final output is shown in the following figure:

But in this case, it may be more convenient for you to create a slicer, just a suggestion:

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.