topic Re: Lookupvalue results missing in DAX Commands and Tips

Lookupvalue results missing

margheritamart — Thu, 23 Nov 2023 13:13:00 GMT

Hi all,

I have tried to create a Lookup between two tables. What I am trying to do is to determine what is the max amount of days that a project can take based on the SLA table. This SLA has a variety of critera: Wordcount, service needed, department and type of material. I have odd results and only one of the max SLA get populated, the rest they do not seem to be matched, anyone would know why?

Re: Lookupvalue results missing

Rupak_bi — Sat, 25 Nov 2023 05:39:13 GMT

please share sample data. and confrim whether all of the criteria has to match or any of the to be matched.

Re: Lookupvalue results missing

v-zhangti — Mon, 27 Nov 2023 08:29:22 GMT

Hi, margheritamart

You can try the following methods.

Column:

Max SLA = CALCULATE(MAX('SLA table'[Max SLA]), FILTER('SLA table',[Department]=EARLIER('WordCountSummary per language'[Department]) &&[Service needed]=EARLIER('WordCountSummary per language'[Service type]) &&[Wordcount bands]=EARLIER('WordCountSummary per language'[Word Count Bands SLA]) &&[Document type]=EARLIER('WordCountSummary per language'[Material type])))

If this does not solve your problem, please provide more data.

Best Regards,

Community Support Team _Charlotte

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

Re: Lookupvalue results missing

margheritamart — Thu, 30 Nov 2023 08:17:08 GMT

Thanks you Charlotte, it worked 🙂