Forum Discussion

Edr2828's avatar
Edr2828
Regular Visitor
4 years ago

Lookupvalue is blank?

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

 

Need Help

2 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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?

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.