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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
NMahan
Regular Visitor

Matrix fails due to exceeding resources when I add a third column

I've got a variable calculated Matrix where within the same column I get the sum of different GL account values, % of revenue, hours, and $ per hour measures.  I've got the report set up to run Year To Date and Prior Year to Date.  I'd like to add a Current Month and Current Month Prior Year as additional columns to that matrix.  Currently, I can run a separate Matrix with those measures with no problem, but when I attempt to add the two additional measures (and effectively additional columns) I get an error about exceeding resources.  I'm very new to report building in Power BI, so can't tell if this has something to do with the measures being built inefficiently or if something else is happening.  See below for a screenshot of the two visuals side by side.  

Screenshot 2023-09-27 155810.png

 

 

 

 

 

1 REPLY 1
christinepayton
Super User
Super User

This is usually an issue with your measure, yeah. Tables and matrixes are comparatively very slow and will run out of resources more often than a chart, too, so you need to try to optimize it. It could also be an issue in your relationships. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.