Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |