LOOKUPVALUE help please

[RvdHeijden]

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 🙂 

[Greg_Deckler · Accepted solution]

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