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
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)