Forum Discussion

Take2's avatar
Take2
Regular Visitor
3 years ago

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.

 

 

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

 

 

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:

 

 

Thank you very much for the help!

Nathan

No RepliesBe the first to reply