selectedvalue not returning all values

[Anonymous]

Hello Guys, 

my problem is, that measure selectedvalue does not show some values.

Measure 

CALCULATE (
  SELECTEDVALUE ( table1 [product] ) ,
       filter ( table1 , table1 [date] = MAX [date] ) )

Results are like this:
( i need to fill blank values in "product" , but measure does not work for all rows, which is strange, because in Data tables im sure, that i have product on ID 589 with that max_date ) 

ID	max_date	product
123	13.3.2022	MOTOR
589	11.2.2022
842	25.2.2022	COMP
564	8.3.2022

[AilleryO]

Hi,

Are you sure not to have duplicates ?

SELECTEDVALUE returns only one value, if there are 2 or more values, then it return the aletrnate result.

Try fill in the 2nd argument of SELECTEDVALUE, the alternate result, to see if it is the case.

Let us know

[amitchandak · Accepted solution]

@Anonymous , Not very clear

Try like

CALCULATE (
Max( table1 [product] ) ,
filter ( table1 , table1 [date] = MAX ([date] ) ))

or

CALCULATE (
Max( table1 [product] ) ,
filter ( allselected(table1) , [Id] = max(Table1[ID]) &&  table1 [date] = MAX ([date] ) ) )

[Anonymous]

second one worked, thank you very much

[AilleryO]

So I think that my guess was OK, you had duplicates ? and the MAX get rid of it ?