Forum Discussion
Solved
Table.Group by aggregate from a RELATED column
I have a MSSDates table that has a relationship with my calendar table. The MSSDates table has a RELATED column in it to identify the day as a working day or not, I want to create a summary table ...
GOT IT! take out the second SUM
Table = GROUPBY(MSSFlatFeeDates,MSSFlatFeeDates[Opportunity],"TotalDays",SUMX(CURRENTGROUP(),MSSFlatFeeDates[WorkingDay]))
GOT IT! take out the second SUM
Table = GROUPBY(MSSFlatFeeDates,MSSFlatFeeDates[Opportunity],"TotalDays",SUMX(CURRENTGROUP(),MSSFlatFeeDates[WorkingDay]))