1 of 1 people found this helpful
Hello Brent Johnson,
Is this article - Resolving "Cannot mix aggregate and non-aggregate arguments" Calculation Error | Tableau Software getting at the issue encountered? You may be able to work around the issue utilizing LOD Calculations because they allow you to compare different measures with different levels of aggregation. here is a good starting point - Top 15 LOD Expressions | Tableau Software
These calculations do not work in every circumstance however they are very useful tools for many situations related to the need for comparisons of metrics at different levels of aggregation.
I had the same Aggregate/Scalar error as Brent and I created a LOD version of the measure at the level I was visualising on the worksheet and I was then able to sort by the LOD version without any problem.