Cannot nest aggregate functions (Error 1844)
Nesting of the aggregate functions MIN( ), MAX( ), and/or the CALCULATE command sub functions: AVG( ), CNT( ), MAX( ), MIN( ), NPV( ), STD( ), SUM( ), or VAR( ), is not permitted.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Nesting of the aggregate functions MIN( ), MAX( ), and/or the CALCULATE command sub functions: AVG( ), CNT( ), MAX( ), MIN( ), NPV( ), STD( ), SUM( ), or VAR( ), is not permitted.