Showing results for 
Search instead for 
Did you mean: 
ColinPelham Frequent Visitor
Frequent Visitor

Calculating Total of SUMX


I'm having some issues using SUMX in a table. I am using the following calculation:


SUMX(FILTER('Table1', [Date]>MAX(Sales[Reporting_Week])),[Value])


This works on a row by row basis for each country in a table, but the grand total picks the max week of any country, then does the calculation from that (so doesn't equal the sum of all the rows).

Is there a way I can work around this?


Thank you for any help,



Super User
Super User

Re: Calculating Total of SUMX

Hi @ColinPelham

Can you share the pbix? That would be helpful. Otherwise explain a bit more what tables of your model are involved in the issue at hand. Use the table name in columns names as well to make the code clearer as in TableName[ColumnName] rather than just [ColumnName]. Is [Value] a measure?

From what you say it might be an issue with (lack of) context transition but it's hard to tell with the info provided.  

Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 319 members 3,504 guests
Please welcome our newest community members: