Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 ) 

IDmax_dateproduct
12313.3.2022MOTOR
58911.2.2022 
84225.2.2022COMP
5648.3.2022 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

4 REPLIES 4
AilleryO
Memorable Member
Memorable Member

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
Super User
Super User

@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 applicable

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 ?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.