This validation is important because sometimes we use dimensions and expressions which are not connected in data model which may create a Cartesian product and may also impact the performance. Say for example when data island tables are used in data model.

You should thoroughly check the dimensions and expression to make sure that logic are properly implemented.

Few other points which are best to be avoided are as follows:

• Use of key fields in count function
• Expression starting with IF conditions.
• Nested IF statements
• IF statement in aggregation function like Sum.
• Custom sorting based on text