Forum Discussion
SUMMARIZE FUNCTION in measures
Hello, I am familiar using desktop and creatigng reports with data imported. Now I jumped into live connectivity and I only can consult tables but not create new ones. I have to base my calculat...
You may want to spend time with this article.
Nested grouping using GROUPBY vs SUMMARIZE - SQLBI
Your second question can be addressed by combining SUMMARIZE, ADDCOLUMNS, and COUNTROWS (or COUNTX if you prefer). It will require multiple steps in your measure (temporary table variables). Watch for context transitions.
lbendlin
Super User
Super UserYou may want to spend time with this article.
Nested grouping using GROUPBY vs SUMMARIZE - SQLBI
Your second question can be addressed by combining SUMMARIZE, ADDCOLUMNS, and COUNTROWS (or COUNTX if you prefer). It will require multiple steps in your measure (temporary table variables). Watch for context transitions.