Tests

Tests checks the behaviour of the model, not only whether an expression parses. Run the suite before and after an important change.

#What the suite checks

• Trusted source SQL compared with the matching DAX measure across the accepted contexts.
• Relationship integrity and table row-count checks.
• Static role, RLS and OLS checks.
• Saved model-interview questions replayed as evidence.
• Dependent-measure failures linked back to the root failing measure.
• Time-intelligence variants checked against their base measure.

#Create a reliable test

1. Choose the measure and the trusted source query.
2. Review the SQL mapping rather than accepting an inferred match.
3. Set the contexts and tolerance.
4. Run the suite and inspect the returned rows.
5. Save the definition beside the model when you want it to run again.