match data

[Naveennegi119]

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

[Anonymous · Accepted solution]

Hi @Naveennegi119

Check your relationship between Emp to MonthData and change it from Single to Both(See the screenshot).

Hope this will help you!!!

[v-jiascu-msft · Accepted solution]

Hi @Naveennegi119,

Please use this formula instead. 

Column =
LOOKUPVALUE (
    Empdata[Weekname],
    Empdata[Weekname], MonthData[Weekname],
    Empdata[EmP], MonthData[EmP]
)

Best Regards,
Dale

[Naveennegi119]

Hi @v-jiascu-msft,

Thanx. for help

Best regards,

NICK

[Anonymous · Accepted solution]

Hi @Naveennegi119

Check your relationship between Emp to MonthData and change it from Single to Both(See the screenshot).

Hope this will help you!!!

[Naveennegi119]

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

[Anonymous]

Hi @Naveennegi119

I have created both side relationship and it's working fine with your data. See the pbix file for more details.

Download pbix file

[Naveennegi119]

Hi @Anonymous,

I know ur solution(what you are trying to teach me). but I can't use it my power bi file because there are already both side relation in my power bi file. I share only the data where I stuck.

Best regards,

NICK