DAX Reviewer
Paste a measure and review it against a checklist you control. The page checks what it can on its own; Copilot covers the rest, suggests a rewrite, and the page tests that the rewrite returns the same numbers.
Connect your model
Optional. With the model, the page can tell columns from measures, check every name exists, give Copilot the formulas of the measures this one uses, and put the test query in the right table.
Paste the measure
Copy it from the formula bar (Name = ...), from TMDL view, or from a DAX query. The name and any TMDL properties are picked out for you.
What the page found
Checked without AI against your checklist, straight away. Line numbers match the listing below. Change the checklist at the end of this step.
Page checks on every measure in the model
The same checks, run on each measure with your checklist settings. Select Review to load one into Step 2 for the full Copilot review.
| Measure | Table | High | Medium | Low | Rules | Review |
|---|
Your checklist
Turn rules on or off and set how serious each one is. Rules marked Page + Copilot are also checked here without AI; your own rules go to Copilot. Your checklist is saved in this browser.
Add your own rule
Ask Copilot for the full review
The prompt carries your whole checklist, what the page already found, and the measures this one uses.
Paste Copilot’s reply
The page merges Copilot’s findings with its own, then checks the rewrite.
Review
Rewrite
Compare with the original
Test it before you change anything
This DAX query runs the original and the rewrite side by side without changing your model. Same should be TRUE everywhere.
Replace the measure with the rewrite
Only once the test shows the same numbers. Run this in DAX query view and select Update model with changes. The format string, folder and description stay as they are. Undo with Ctrl+Z if needed.