Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Return a distinct value from a column

Hi there, I have a table looking like this: ID anotherID Valid Value 1 1 01.01.2023 0,5 2 5 01.01.2023 1,5 3 4 01.02.2023 2,5 4 2 01.02.2023 3,5 1 1 01.02.2023 0...
  • ERD's avatar
    ERD
    2 years ago

    Hi Anonymous , is this what you'd like to achieve?

    v1 = CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table' ), 'Table'[anotherID] IN VALUES ( 'Table'[ID] ), VALUES('Table'[Valid]) )
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous , is this what you'd like to achieve?

v1 = CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table' ), 'Table'[anotherID] IN VALUES ( 'Table'[ID] ), VALUES('Table'[Valid]) )