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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

GMSPrem-lAb0GwAccepted solution

Level 2

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

GMSPrem-lAb0GwAccepted solution

Level 2

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

Translate

Sign up