Hi. I'm kind of new to Power Pivot/DAX and I'm having some trouble with a SUMX to get the correct total for my measure. My measure is made up of two other measures all from the same table. Following is detail of the situation with some of the names simplified since I can't paste from my employer. The base of the measure is fairly basic =ROUND([Amount]*[Percent],2). My entire measure is =IF(HASONEFILTER(Table[Account Num]),ROUND([Amount]*[Percent],2),SUMX(Table,ROUND([Amount]*[Percent],2))). The account level values are correct but the total amount from the SUMX is not.... but I can't figure out why. I stripped out all other filters etc. to make sure it wasn't a pivot context issue, still no luck. To test further, I copied the pivot data (Account Num, Amount & Percent) and pasted values into a separate file, loaded it into a data model and tried same measure =IF(HASONEFILTER(.... ) . In this case with the calculation being column based from the data model, the total from SUMX was correct. Is there some sort of "trick" to using SUMX with calculation that is based solely on other measures (rather than data model table columns)? Please help.