Forum Discussion
match data
Hi All,
download power bi file link:- https://drive.google.com/file/d/1VyzLTsDMqCvo6JpQcKprJKCxoDLgMTqD/view?usp=sharing
let me explain what is the problem
Now you see image when I select EmP-01 from slicer it matching value perfectly.
but when I selected EmP-02 from slicer, there only three weekname in EmPdata but matching column show four weekname. it's contain EmP-01 weekname also.
Tried many dax, nothing get
in this pbix I'm using Column = LOOKUPVALUE(Empdata[Weekname],Empdata[Weekname],MonthData[Weekname]) this.
I want only show match data referance of EmP slicer.
Best Regards,
NICK
Check your relationship between Emp to MonthData and change it from Single to Both(See the screenshot).
Hope this will help you!!!
Hi Naveennegi119,
Please use this formula instead.
Column = LOOKUPVALUE ( Empdata[Weekname], Empdata[Weekname], MonthData[Weekname], Empdata[EmP], MonthData[EmP] )
Best Regards,
Dale
7 Replies
Check your relationship between Emp to MonthData and change it from Single to Both(See the screenshot).
Hope this will help you!!!
Hi Anonymous,
I have many relationship in my power bi file. both side relationship already relate with data. So it's occuring error.
but thanks to reply and help.
I try to figure out your solution work for me.
Best Regards,
NICK
I have created both side relationship and it's working fine with your data. See the pbix file for more details.
Hi Naveennegi119,
Please use this formula instead.
Column = LOOKUPVALUE ( Empdata[Weekname], Empdata[Weekname], MonthData[Weekname], Empdata[EmP], MonthData[EmP] )Best Regards,
Dale
