The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
14 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
28 | |
18 | |
13 | |
7 | |
5 |