Slicer which filters between two tables with same datatypes

[Anonymous]

Hi all,

So I'm working on a project and is in dire need of help.

So I have a project where there exist two different sites, both of these sites gather the same datatypes, but have their own name i.e: Erdin and Oto

What I've done so far, is to create an ID for both of these tables(sites) and created a separate with the ID and name of the site to create the relationship.

What am I doing wrong? Do I need to create a measure which makes it possible to take values from either site?

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I'm a little confused about the scenario. Is this slicer not working? Or you can't get the expected result when you filter it?

Can you please share a dummy file or sample data and expected result? Then we can help you as soon as possible.

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

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I'm a little confused about the scenario. Is this slicer not working? Or you can't get the expected result when you filter it?

Can you please share a dummy file or sample data and expected result? Then we can help you as soon as possible.

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

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi Xue, 

I managed to solve the issue myself. I will take the link you attached into account and make a more thorough description next time.