Tableau: How to Solve “Cannot Mix Aggregate and Non-Aggregate” Errors
Updated: May 13, 2021

Let’s start with a simple example. Within a single calculation, all parts of a calculation must be either aggregated or not aggregated.
This calculation is not aggregated.
[Sales] / [Profit]

This calculation is aggregated.
Sum([Sales])/sum([Profit])
