How to show all values of a calculated dimension in a straigth table

[marcobombo1]

Hello,

I would like to display a straight table with a dimension that is the year with all its values, even if I have selected the year in the list box. I tried with this calculated dimension =aggr(only({1<year=>} year),year), but it doesn't work.

Any ideas? I attach small example.

[Gysbert_Wassenaar · Accepted solution]

You'll have to override  the selection in the measure too: sum({<anno>}anz)

[marcobombo1]

Thanks Gysbert, it works great!!!