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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Take2
Regular Visitor

SUM Specified Row Items For All Higher Matrix Levels WITHOUT Using Iterators

Hello Community,

 

This site (https://radacad.com/calculate-totals-in-power-bi-using-iterators-in-dax ) makes the following claim:

 

"SUMX and Iterators are only one of the ways that can help you to create the totals, but it is not the only way.

Sometimes, you might find the performance of iterator functions slower than other methods.

 

Take2_0-1690235704867.png

 

If what RADACAD says is true, then there are other ways to recalculate the totals based on the SUM of row items.

Would someone be kind enought to show me 1 or 2 other ways (without the use of iterators) to accomplish the following?

 

Here is the link to the PBIX: 

https://drive.google.com/file/d/1vdZmj0n0-JpCXnQ6kqTgxxjGW_8x-rx8/view?usp=drive_link

 

The following Rows exist in the below Matrix:

- SalesRep Name

- Customer Name

- Product Name

 

Take2_1-1690235889339.png

 

ISSUE: The values highlighted in yellow are not correct.  Instead, they should be the SUM of Isolated Type 2 Desired Values ([z1 Isolate T2 Desired Values]).

 

DESIRED RESULT:

 

Take2_2-1690235940589.png

 

Thank you very much for the help!

Nathan

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 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.