Hello,
Based on table below, I wish to create two measures 'total_metric1' and 'total_metric2'. However, the correct total as per my use case for total_metric1 = 500 and total_metric2 = 1700. At the moment, PBI is totaling it as 1000 and 3400 respectively.
How can I achieve this optimally via DAX?
So if you add 01B or 02B to a card visual, they work.
However, if you try to add them to the table visual, you get the following error:
"SummarizeColumns() and AddMissingItems() may not be used in this context."
That's annoying.
The following link provides guidance that we should replace SUMMARIZECOLUMNS with ADDCOLUMNS+SUMMARIZE.
So I have modified the code here in 01C & 02C.
As a result, these now work correctly within the table visual, as shown.
Regards,
Nathan
So if you add 01B or 02B to a card visual, they work.
However, if you try to add them to the table visual, you get the following error:
"SummarizeColumns() and AddMissingItems() may not be used in this context."
That's annoying.
The following link provides guidance that we should replace SUMMARIZECOLUMNS with ADDCOLUMNS+SUMMARIZE.
So I have modified the code here in 01C & 02C.
As a result, these now work correctly within the table visual, as shown.
Regards,
Nathan
Helpful resources
Power BI Dataviz World Championships
Vote for your favorite vizzies from the Power BI World Championship submissions!
Join our Community Sticker Challenge 2026
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
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.
| User | Count |
|---|---|
| 17 | |
| 10 | |
| 6 | |
| 5 | |
| 5 |
