Cannot create %1!s! on view "%2!s!" because it uses aggregate "%3!s!" with the DISTINCT keyword. Consider not indexing this ...

Cannot create %1!s! on view "%2!s!" because it uses aggregate "%3!s!" with the DISTINCT keyword. Consider not indexing this view or eliminating DISTINCT. Consider use of a GROUP BY or COUNT_BIG(*) view to simulate DISTINCT on grouping columns.