The "cannot mix aggregate and not aggregate" error can be resolved several different ways depending on what you need the calculation to do. Check out Error "Cannot mix aggregate and non-aggregate arguments with this function" When Creating a Calculated Field | Tableau S… for all of the options.
In this case, you might want
IF MIN ([Currency Measure]) = MAX ([Currency Measure])
ELSE SUM([Total Revenue (Local)])
Hope this helps