Filter table and then apply formula to said filter

[Dalton948]

I am trying to do a lookupvalue formula on filtered data. I am having issues combining the two.

The goal is as follows:

Filter table 1 to only return values that = a sepcific value in a column.
Lookupvalue on table 1 to pull\match data from table 2.
Have a new column created that returns what im wanting onto table 1.

Currently i transform the data in table 1 and then do the lookup value. Trying to see if can consolodate it into a formula to save some space.

Quick example Table

Table 1
Name	Created By
Task	John
Incident	Mark
Task	Cindy
Incident	Albert
Task	Tom
Table 2
Department	Name
IT	John
IT	Tom

So i need to Filter to only return data that results in Task under the name column on table 1 and then i want to run a lookup value formula matching on name and returning IT from department when it matches. which looks like,

LOOKUPVALUE(table 2[department],table 2 [name],table 1[created_by]). But i'm having issues applying the filter and then adding that.

[Dalton948 · Accepted solution]

Yeah, i wrapped my lookupvalue formula in an if() statement.

IF(Table1[NAME]="sc_task",lookupvalue(table2[department],table2[username],table1[created by]))

[Dalton948]

Solved with an if statement

[v-junyant-msft]

Hi @Dalton948 ,

You mentioned that you have solved it, so could you please post your solution (DAX) below and accept it as a SOLUTION to make it easier for more users experiencing similar problems to find a solution faster, thank you!

Best Regards,
Dino Tao