Downloads

Performance and troubleshooting

Make DAX fast, read common error messages, and debug a wrong number.

Last updated

View as Markdown For AI agents All guides as text

On this page

You'll be able to

  • Write DAX that runs fast, and measure how long a query takes.
  • Read the common DAX error messages and fix them.
  • Follow a step-by-step routine to find why a number is wrong.
  • Apply the style conventions that prevent bugs.

Writing fast DAX

Measuring performance

Style conventions that prevent bugs

Troubleshooting common errors

Debugging technique

Reproduce the number in a table visual with the pieces beside it: show the grouping column, the unfiltered measure, the filtered measure, and the count of rows (COUNTROWS(Sales)). In DAX query view, EVALUATE SUMMARIZECOLUMNS(...) with the same filters shows what the measure sees. Replace measures with their base parts one by one until the number changes. Use CONCATENATEX(VALUES(...)) measures to display what a context holds.

Want to see it run?

Open a finished Power BI project or Excel workbook built on the same data, or ask an AI assistant that has read these guides.