Forum Discussion
CJ_96601
Helper V
Helper VSum Value based on distinct record from other column
Need to sum up values of the largest amount based on badge number and based on selected year. Below is the sample table for easy reference. I appreciate your help
Bold data (the largest of the amount for each badge number) to be added.
| BadgeNo | Amount | Year |
| 1 | 2000 | 2018 |
| 1 | 3000 | 2018 |
| 1 | 1000 | 2019 |
| 1 | 5000 | 2018 |
| 2 | 6000 | 2018 |
| 2 | 8000 | 2018 |
| 2 | 2000 | 2019 |
| 2 | 5000 | 2018 |
| 3 | 2000 | 2018 |
| 4 | 5000 | 2018 |
| 4 | 6000 | 2018 |
| 5 | 5000 | 2018 |
| Total for Year 2018 (based on the largest amount per badge number | 26000 |
16 Replies
- PattemManohar
Community Champion
CJ_96601 Please create a new table as below and use the Year and Amount field from this new table in your visuals.
Test219Out = SUMMARIZE(Test219MaxSum,Test219MaxSum[Year],Test219MaxSum[BadgeNo],"Amount",MAX(Test219MaxSum[Amount]))
