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 [dat...
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 , 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] ) ) )
second one worked, thank you very much
So I think that my guess was OK, you had duplicates ? and the MAX get rid of it ?
