DAX measure using CALCULATETABLE with an measerue

Hi,

Using the example file you posted, the part:

CALCULATETABLE( Table1, Table1[Sales] < 10 )

will produce the following table:

Product	Sales
a	8
b	2
c	3
b	7
c	2
a	4
b	6
c	8
d	3
a	3
d	2
a	2
b	7
c	5

SUMX then iterates through each row within this table and calculates the value of [Total Sales Measure] for each row. To do this, it filters the original Table1 according to the Product/Sales combination in each row of the above and then sums the resulting rows. For example, for the first row in the above table, you will be filtering the original Table1 for Product="a" and Sales=8, and for each row which matches these criteria you take the sum of the Sales.

For the vast majority of cases, the paired entries (Product/Sales) in the above table occur just once in Table1, apart from one combination (b|7), which appears twice. As such, each b|7 entry in the above table returns a total of 14, not 7, thus making your overall total 14 greater than that for the equivalent measure but using Table1[Sales] in place of [Total Sales Measure].

Regards