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

AilleryO's avatar
AilleryO
Memorable Member
4 years ago

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