Forum Discussion
Solved
Help with matrix calculations
I need help with calculating totals in a matrix. I work at a college and we have some crosslisted sections within a course. For example, we may offer one section of Piano I all by itself. We may ...
The two methods suggested in this thread resulted in the same counts as my original (in blue).
Solution A (green): Include [Capacity Stacked] in SUMMARIZE and added [Capacity Stacked] after SUMMARIZEXListTest1 =SUMX(SUMMARIZE('XLIST','XLIST'[Division],'XLIST'[Department],'XLIST'[Subject],'XLIST'[SEC_COURSE_NAME],'XLIST'[SEC_NO],'XLIST'[XListCourse],"Capacity Stacked", [CapacityStacked]),[Capacity Stacked])Solution B (orange): Exclude [Capacity Stacked] in SUMMARIZE and added [Capacity Stacked] after SUMMARIZEXListTest2 =SUMX(SUMMARIZE('XLIST','XLIST'[Division],'XLIST'[Department],'XLIST'[Subject],'XLIST'[SEC_COURSE_NAME],'XLIST'[SEC_NO],'XLIST'[XListCourse]),[CapacityStacked])A colleague provided the correct solution, which has two parts. First, group the section numbers.
Step 1: Create column in table:GroupID = COALESCE ( 'XLIST'[SEC_NO], 'XLIST'[XListCourse] )
Step 2: Create measure.
XlistCorrect =SUMX (VALUES ( 'XLIST'[GroupID] ),CALCULATE ( MAXX ( 'XLIST', 'XLIST'[Cap] )))THANK YOU for your help! I learned a lot from all of you and I hope the solution is helpful to others!
Hi dilmatz0401 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.