Forum Discussion
selectedvalue not returning all values
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 |
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] ) ) )
4 Replies
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] ) ) )So I think that my guess was OK, you had duplicates ? and the MAX get rid of it ?
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
