Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
  • amitchandak's avatar
    5 years ago

    Anonymous , Try a measure like

    sumx(distinct(Table[QTD]), [QTD])