What are the common scenarios in which the Grand Total does not equal the sum of rows in both countable and summable measures?

A common issue arises when using the DISTINCTCOUNT function, where the grand total may not align with the sum of individual rows.

If you’ve used a measure that involves row context in the calculation, the grand total might not match the total of the rows. To resolve this, you can adjust the calculation by incorporating VALUES or SUMMARIZE together with SUMX.