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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a measure like

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

NJ13's avatar
NJ13
Helper I
4 years ago

amitchandak how about if i want to sum distinct values for QTD based on their codes for the most recent date submitted?