Ranking position in the ranking in and …

Hola

I’m struggling to top the previous year’s rankings and thus be able to calculate if the topic has increased or decreased in popularity.

The table is set up like this, but it is obviously very large

Trying to visualize something like this (this in Excel for a visual appearance, not reproducible in Power Bi)

I can make the ranking work for the grand total, but he doesn’t seem to like going beyond the previous year.

I have tried all kinds of them, creating measures, etc. Without any success.

Any help to point me in the right direction would be great.

A thousand thanks

Tear