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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
The below measure working by itself, but If I refrence in another measure for calculation it will give me an error. here is the
error: mdxscript(model) (1276, 1) calculation error in measure summarizecolumns() and add missing items
SUMMARIZECOLUMNS()
what do I need to change in this measure?
Solved! Go to Solution.
Using SUMMARIZECOLUMNS is not allowed for measures and calculated columns. You can use it only in queries and calculated tabl s.
you can replace it with SUMMARIZE with some modifications.
Using SUMMARIZECOLUMNS is not allowed for measures and calculated columns. You can use it only in queries and calculated tabl s.
you can replace it with SUMMARIZE with some modifications.
Thank you!
User | Count |
---|---|
15 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
30 | |
18 | |
11 | |
7 | |
5 |