Forum Discussion
Sum based on text and value
Hi Experts
i need to sum based on client ID - so aaa should give me 2.25 and bcb 7 in a table as measure
| Client ID | Data Value |
| aaa | 1 |
| aaa | 0.5 |
| aaa | 0.75 |
| bcb | 1 |
| bcb | 2 |
| bcb | 4 |
| bcb | 1 |
Anonymous ,
sumx(summarize(Table, Table[client], Table[data value]), [Data Value])
1 Reply
- amitchandak
Super User
Anonymous ,
sumx(summarize(Table, Table[client], Table[data value]), [Data Value])