The common approach is to re-shape the datasource
(using either Tableau Pivot or general 'Scaffold' technique)
to have (some) Measure Names / Values as Pivot Names / Values,
then use MAX() or WINDOW_MAX() aggregation
across those Pivot Names (Dimension) values.
If the above sounds complicated, there would be another approach --
using different views (one per each Measure) arranged on a dashboard.
Please find the attached as an example of the latter.
Frankly, it would be as complicated as the former :-)
Book1_v10.5_YF.twbx 7.6 MB
I read about the PIVOT option on the community. When I select the fields I don't see the Pivot option at all. For now, I am highlighting the number but there's got be an easier to do this. I would imagine every company would have this requirement. I am surprised, there is so much work that needs to be done to achieve this instead of a single click.