Forum Discussion
Fixing Filter Measure
Hi all,
I'm trying to use the below measure to lookup a value in a table where I have a unique code
VAR Selected_Date = 'Table1'[Date]
RETURN
LOOKUPVALUE
(
FILTER('Table1', Selected_Date = 'Table1'[Date]),
'Table1'[Numbers],
'Table1'[Unique Code],
'Table2'[Unique Code]
)
Any ideas why this isn't working?
4 Replies
TotunG ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.I have a table like below:
ID Month Calculated Column SASDSK2 JAN ERROR SFAFAC FEB ERROR
SDADSFA5 APRIL ERROR SFAFA4 MAR ERROR The calculated column is trying to LOOKUP the value that is found in another table (seen below), but obviously this table has multiple 'Years' in it so it will find multiple values. Therefore I need it to interact with a 'Year' slicer or FILTER the table by a 'YEAR' so it only finds the 1 ID per 1 year. It can be converted into a measure which I think is easier but none of my formulas are working.
ID Value Needed Year SASDSK2 5 2022 SASDSK2 6 2019 SDADSFA5 2 2022 SDADSFA5 5 2021 SDADSFA5 6 2020
Hi,
Please use min/max date in the variable, if you are using measure then this would dynamically filter to the selected period
VAR Selected_Date = MAX('Table2'[Date])
RETURN
LOOKUPVALUE(table1[value] , table1[date] , Selected_Date ,table1[uniqueid] , table2[uniqueid])
It doesn't let me reference table1[value] in this. It only lets me reference Table2 columns or the relationship table the code's are linked by.
