Forum Discussion
Solved
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 :)
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])
1 Reply
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])