Dynamic title with multiple years selected

[mtrevisiol]

Hi everyone.

I'm trying to create a dynamic title that shows the quantity bought from a certain selected supplier in one ore more years, i.e.:

The problem is that it doesn't show me any selected year, even in the case I select only one single year.

This is the measure I wrote:

Can you help me? Thanks!

[V-lianl-msft]

Hi @mtrevisiol ,

Based on your description, I created a test file, which runs well with the same measure.

Please check the relationship between the date table and other tables.

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

[mtrevisiol]

Hi @V-lianl-msft, thank you for the answer. Where can I find the file?

[V-lianl-msft · Accepted solution]

You could check the below pbix file:

[mtrevisiol]

Tjank you so much, @V-lianl-msft !

[amitchandak]

@mtrevisiol , change concatenateX like

concatenateX(values(Calendar[Date].[Anno]), calculate(max(Calendar[Date].[Anno])))

My advice would be to create a year column and use that in place of [Date].year