This expression could impact performance The list of values of column ID

[DouglasBusa]

Good morning I'm in trouble

I have a problem, I believe it's just due to lack of competence on my part, but if anyone can help I'll be grateful!

I have two tables, one called sales with the column PLAN and another called Planos Unifique, with the column SITUATION and
PLAN NAME

So I created the formula:
FILTER("Unify Plans", [SITUATION] = "ACTIVE")

this was done so that the PLAN column of the sales table is filled (enum) only with the plans with the status ACTIVE, however it is returning only the result of the ID column

someone help me with this problem please!

[diogolupcosta · Accepted solution]

Switch the expression to: 

SELECT(Unify Plans[PLAN NAME], [SITUATION] = "ACTIVE")

[DouglasBusa]

perfect my friend, now still abusing your goodwill

when selecting the product from the SITUACAO column, for example, test plan, that same line has the value column and I would like to complete that value in another field of the table with that same select

I did it with PROCV() before adding the new sale, I would like the value to appear in the field below when selecting the plan