MySQL Error: This measure must be an aggregation / A Measure must be aggregated

Since we haven’t optimized our MySQL Data Modeling to work with SQL mode ONLY_FULL_GROUP_BY disabled, the measure couldn’t be validated.

If you are facing this error, please try to enable this SQL mode ONLY_FULL_GROUP_BY in your MySQL settings and try to create that measure again

You can follow this link to learn more about this SQL mode