Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

second one worked, thank you very much

AilleryO's avatar
AilleryO
Memorable Member
4 years ago

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