Forum Discussion
How to do sum for a distinct column
Hi , I have 4 columns: Network Team, Pre sales, Demo score and Demo code. Now i need to filter distinct demo code and get the sum of demo score for the filtered demo codes. output should have sum ...
please neeed help
- amitchandak
Super User
Sumx(Summarize(Table, Table[Demo code], Table[Demo Score]), [Demo Score])
Or
Sumx(Summarize(Table, Table[Demo code], "_1",Max(Table[Demo Score]) ), [Demo Score])
