Return a distinct value from a column

Anonymous — Wed, 29 Nov 2023 14:42:18 GMT

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,55
2	5	01.02.2023	1,55

And I am trying to return the value from column value by looking up the entries in column "anotherID" in column "ID". With my current measure, I do return the sum of "values", but I would like to have the filter also set on the valid date.

See here my measure:

CALCULATE(SUM(Table[Value]), ALL(Table), Table[anotherID.] IN VALUES (Table[ID]))

But this returns for ID 1 for example the sum of 0,5 and 0,55 --> 1,05

How can I add the Filter for the explicite date? I have tried to extend the calculate measure but nothing changes.

CALCULATE(SUM(Table[Value]), ALL(Table), Table[anotherID.] IN VALUES (Table[ID]), Table[Valid]) --> does not return the right value.

Thanks for your help.

Re: Return a distinct value from a column

ERD — Wed, 29 Nov 2023 15:23:44 GMT

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]) )

Re: Return a distinct value from a column

Anonymous — Mon, 04 Dec 2023 10:29:25 GMT

Thank you!

topic Re: Return a distinct value from a column in DAX Commands and Tips

Return a distinct value from a column

Re: Return a distinct value from a column

Re: Return a distinct value from a column