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 | |
| Z | 9 | Z | 3 | |
| X | 4 | |||
| Y | 5 | |||
| Z | 6 |
Sudharsanan , A New column in table 1
SumX(filter(Table2, Table1[Name] = Table2[Name]), Table2[Count] )
4 Replies
Sudharsanan , A New column in table 1
SumX(filter(Table2, Table1[Name] = Table2[Name]), Table2[Count] )
