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