Forum Discussion
Help with matrix calculations
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!
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 SUMMARIZE
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.