The Definitive Guide to DAX, Third Edition

Errata corrige

To ensure the ongoing accuracy of this book and its companion content, we have reviewed and confirmed the errors listed below. If you find a new oversight not included in both of the following sections, please report it to us.

Important issues

No important issues have been reported yet.

Minor issues

• Page 19: SUMX instead of SUM

  The measure defined in the second line of the first code snipped should be SUMX instead of SUM. The correct first two lines are as follows:

  DEFINE
      MEASURE Sales[Sales Amount] = SUMX ( Sales, Sales[Quantity] * Sales[Net Price] )
  

  Dec 20, 2025
• Page 57: Inaccurate calculation in the Occurrences measure

  The implementation of the # Occurrences measure counts the number of keywords, not the number of products that contain at least one of the keywords mentioned.

  A correct version of the calculation is the following:

  # Occurrences = 
  COUNTROWS (
      FILTER (
          'Product',
          COUNTROWS (
              FILTER ( 
                  Keywords,
                  CONTAINSSTRING ( 'Product'[Product Name], Keywords[Keyword] )
              )
          ) > 0
      )
  )
  

  The only difference in the result is the Total, which is 900 instead of 943 for # Occurrences and 35.76% instead of 37.47% for Perc.

  However, for the purpose of this initial introduction, this is a minor issue. The goal was to expose the syntax of two nested iterations that will be explained later in the book.

  Jan 2, 2026
• Page 128: Sum instead of average

  In the first paragraph of the page, immediately before Figure 4-15, the noun “average” should be “sum” in the second sentence, which should be read as follows:

  Therefore, the value computed is the sum of all brands in the given year, …

  Jan 8, 2026
• Page 168: Figure 5-5 label correction

  The Figure 5-5 label should say “two ore more products” instead of “more than two products”. The correct label is:
  FIGURE 5-5 # Good Customers shows the customers who bought two or more products.

  Jan 4, 2026
• Page 172: Net Price should be Unit Price column reference in code snippet

  The code snippet iterates Product[Net Price] instead of Product[Unit Price]. The right code snippet should be as follows:

  SUMX (
      VALUES ( 'Product'[Unit Price] ),
      IF (
          'Product'[Unit Price] >= 10,
         'Product'[Unit Price] * [Sales Amount]
      )
  )
  

  Jan 4, 2026
• Page 471: Incorrect table headers in Figure 12-17

  The Sales and Product table headers in Figure 12-17 should be removed from the figure, they are unrelated to the content displayed.

  Nov 25, 2025
• Page 491: Missing assignment operator in DAX measure

  There is a missing “=” assignment operator after the line VAR Result in the 6 Months Avg measure. The correct code of the final part of the 6 Months Avg measure should be:

  VAR Result =
      IF (
          [Sales Amount] > 0,
          MovingAverage
      )
  RETURN Result
  

  Nov 25, 2025
• Page 556: DATESINPERIOD instead of PARALLELPERIOD

  In the first line of the last paragraph of the page (before Figure 13-30), the sentence should reference DATESINPERIOD instead of PARALLELPERIOD.
  The right version is: “The second argument of DATESINPERIOD is the reference date, …”

  Jan 7, 2026
• Page 608: Internal note to ignore in Figure 14-38

  The note ** insert F14xx38 no crop on the top of Figure 14-38 should be ignored, it is an internal editing note that was left in production by mistake.

  Jan 9, 2026