Forum Discussion
Solved
sum by group
Hi All, Can someone help me to get the below Consolidated result using dax please? Table A Table B Name Consolidated count Name Count X 5 X 1 Y 7 Y 2 ...
Sudharsanan , A New column in table 1
SumX(filter(Table2, Table1[Name] = Table2[Name]), Table2[Count] )
Sudharsanan , A New column in table 1
SumX(filter(Table2, Table1[Name] = Table2[Name]), Table2[Count] )
it worked amitchandak