Forum Discussion
Anonymous
5 years agoNot applicable
SUM only distinct values
Hello, My table follows this structure: CODE DATE QTD AA 12/12/2020 5 AA 12/12/2020 5 AA 26/12/2020 8 BB 28/12/2020 2 BB 31/12/2020 2 I...
- 5 years ago
Anonymous , Try a measure like
sumx(distinct(Table[QTD]), [QTD])
maciek971
5 years agoNew Member
Hi,
I have a similar issue but based on the example above I'd like to SUM content of column B only once per unique row examined by the content of A column.