Sum values of all rows that contains the same values in determinated cells (like a matrix does)
Hi, I wanted to create a column (used for further calculations) where I sum the hours of all rows that are part of the same [code_name] that contains a determinated string ("work")
Col = SUMx(FILTER('table','table'[code_reason]="work"&& 'table'[code_name]=EARLIER('table'[code_name])),'table'[hours])
It show the right results, the problem is that I have a time slicer but even if you filter the dates the value of this column dont change. Looking for an answer I saw that I should use a measure for this, but copy pasting the formula doesnt work.
Also using a matrix visualization with rows: code_name, column: code_reason, values: hours already show the correct values