Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 20 | |
| 12 | |
| 11 |