Fixing Filter Measure

[TotunG]

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?

[VigneshSub]

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

[TotunG]

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. 

[amitchandak]

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

[TotunG]

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