Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter one table by another one table

Hi, I'm new here, Could you please help me? I have problem with filtering data, I have two tables, In 1st there is document name and document catergory in 2nd is document name and amount to count....
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,

    I checked data source and it's turned out  document name in both spreasheets has different naming scheme, short and long, so for Power Bi there were completely different documents. My mistake, I missed it during initial data checking and I focused just on Power Bi. It was reason why filter didn't work

    I think problem will be solved after change all names to one scheme

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

I checked data source and it's turned out  document name in both spreasheets has different naming scheme, short and long, so for Power Bi there were completely different documents. My mistake, I missed it during initial data checking and I focused just on Power Bi. It was reason why filter didn't work

I think problem will be solved after change all names to one scheme

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous

 

As you want to filter amount by category, you should modify the relationship to single 1st table filters 2nd table. And after changing all names to one scheme, if it's possible to make the document names in 1st table unique, you can modify the relationship to 1 to many. This would be better. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.