Lookupvalue is blank?

[Edr2828]

I am trying to get the Lookupvalue function to pull a number from a table. I have three relationships in the table, all are working. Yet when I run the query the amounts are coming up blank? The four other columns populate accurately. What am I doing or not doing?

fwiw - my query works all the way to this last step

Budget Model = 
        ADDCOLUMNS(
        SUMMARIZE(
            'IMR',
            'CLT GRP'[CLIENT GROUPS],
            'STATE'[STATES],
            'DATE'[NUM MO]
        ), 
            "@PCT",
            DIVIDE('IMR'[COLL IN 2020],
            CALCULATE('IMR'[COLL IN 2020],REMOVEFILTERS('DATE'[NUM MO]))
            ),
            "@BUDGET",
                LOOKUPVALUE(
                    'BUDGET SCENARIOS'[BUDGET AMT],
                    'BUDGET SCENARIOS'[STATE],'STATE'[STATES],
                    'BUDGET SCENARIOS'[CLT GRP],'CLT GRP'[CLIENT GROUPS],
                    'BUDGET SCENARIOS'[SCENARIO],"LOW"
                )
        )

[v-xiaotang]

Hi @Edr2828 

"I am trying to get the Lookupvalue function to pull a number from a table. " Could you share some data and the expected result to show what you are trying to do/get?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[SpartaBI]

Hard to tell without seeing exactly the budget table,but is it possible you have multiple rows in the result of the lookup? This will return a blank. Maybe the granularity of your Budget table is higher than state, group and scenario?