cancel
Showing results for
Search instead for
Did you mean:
Post Prodigy

## LOOKUPVALUE help please

Guys, i need some help with this formula.

test = LOOKUPVALUE(Taken[Onderaannemer];Taken[DP gebied];Onderaannemer[DP gebied])

Ive got a table called 'Taken' which has multiple values of 'DP gebied' which means that this value isn't unique in the list.
Ive made a new table which summarizes these values so they are unique.

Now here is the problem, i need to LOOKUPVALUE the team which is responsible for that 'DP gebied' but i get the error that there are multiple values where one is expected.
So i wanted to adapt the formula to coop with this but im not sure how.

In the table 'Taken' there are 2 types of Activities lets call them A and B and this lookupvalue should only return the value if its activity A because activity B has other people doing it and that probably triggers the error.

Who is game and can help me on a saturday 🙂

1 ACCEPTED SOLUTION
Super User

This would be far easier with data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, forget LOOKUPVALUE and try something like:

```Column =
VAR __dpgebied = 'Onderaannermer'[DP gebeid]
VAR __table = FILTER(ALL('Taken'),'Taken'[DP gebeid] = __dpgebied && 'Take'[Activity] = "A")
RETURN
MAXX(__table,[DP gebeid])```

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition
1 REPLY 1
Super User

This would be far easier with data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, forget LOOKUPVALUE and try something like:

```Column =
VAR __dpgebied = 'Onderaannermer'[DP gebeid]
VAR __table = FILTER(ALL('Taken'),'Taken'[DP gebeid] = __dpgebied && 'Take'[Activity] = "A")
RETURN
MAXX(__table,[DP gebeid])```

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

## Helpful resources

Announcements

#### Check it Out!

Click here to learn more about the August 2022 updates!

#### Check it Out!

Mark your calendars and join us on Thursday, August 25 at 11a PDT for a great session with Ted Pattison!

#### The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

#### Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors