Forum Discussion
Sum per group (with PBI example file)
Hi guys, i have a table looking like this and i want to create the Group sum in each row for each article. So basically i want to add the numbers in the red circle as a measure to the table: ...
So I would think:
Measure = VAR __Group = MAX('Table'[Article Group]) VAR __Table = FILTER(ALL('Table'),[Article Group] = __Group) RETURN SUMX(__Table,[Stock reach days])
Greg_Deckler
Community Champion
Community ChampionSo I would think:
Measure =
VAR __Group = MAX('Table'[Article Group])
VAR __Table = FILTER(ALL('Table'),[Article Group] = __Group)
RETURN
SUMX(__Table,[Stock reach days])Perfect it works! Thansk alot