Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ColinPelham
Frequent Visitor

Calculating Total of SUMX

Hello,


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,

 

Colin

1 REPLY 1
AlB
Super User
Super User

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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.