Forum Discussion
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