Why do you always have to select distinct on add data aggregates?

[Former Community Member]

Seems to me if you group by all the dimensions and aggregate the measures you shouldn't have dupes?

[GMSPrem-lAb0Gw · Accepted solution]

Yup! Glen you are right .. We always use distinct to avoid duplicates while grouping.