The greatest measure

by Alexandra Hanna

This week my project required to fix the axis of multiple dot plots across several sheets in a Tableau workbook. To do this, I needed to find the possible greatest number of set of five measures which changed dynamically when applying a customer ID filter:

Set of five measures that will be displayed singularly per sheet, which require a synchronized axis for the dashboard.









Using the max() function it is possible to return the biggest record of a single or double expression. Therefore, I employed two calculated fields separetely  to find the highest number of two pairs of measures at a time:





The next step was to compute these against each other, and finally against my last measure:






Finding the biggest number of dynamically changing fields is simple but involves multiple nested calculations.


Alexandra Hanna

Power BI venture

2 mins read

Mon 02 Nov 2015

Tableau Countdown

2 mins read

Thu 29 Oct 2015

Tweaking Tableau Server

2 mins read

Sun 06 Sep 2015

No guns allowed

1 mins read

Thu 27 Aug 2015