Max Total Sales in Matrix by Year and Countries

DAX
1

Dear community,

I’m trying in a Matrix to retrieve the Maximum Total Sales of all the Year by countries. Very simple in theory, but it seems more complex in reality as I need to remove the Year filter to place the measures inside the matrix. But removing the all(Year) also changes the context of my Max formula. I tried turnaround with Supporting tables, but it doesn’t seem to work as I loose the Year with my technics.

Any straight forward methods? Faced this problematic more than once :slight_smile:

Thanks for you help!
Mark Lovejoy

PBI test Mark Lovejoy.pbix (31.4 KB)
Desired result.csv (140 Bytes)
Data for Test.xlsx (11.9 KB)