DAX

[Sowmiya]

Hi Community,
Help me with DAX to obtain multiple selected values from filter.


measure=selectedvalue(table[year]) => When single year is selected, measure returns 2016.

When multiple year is selected, help me with dax to display the multiple selected year.

Thanks in Advance,
Sowmiya.

[AlB · Accepted solution]

Hi @Sowmiya

How about

Measure =
CONCATENATEX ( VALUES ( 'Table'[Year] ), 'Table'[Year], ", " )

or any other delimiter of your liking instead of ", "