Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
@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] ) ) )
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
@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 ?
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |