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 https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sqlmode_only_full_group_by