Group By Tand filtering

[erhan_79]

Hi there ,

İ have a question about below topic :

i have a table which is calling table A and i am duplicating this table on power query side.

new duplicated table name is table B , and imagine that i am making group by on table B . then i go to power bi desktop and create 2 table vision one of them include table A colums , other one include table B columns.

when i want to filter one of table A column on filter pane ( filters on this page section ) , it does not affect the table vision that i created with the infos table B columns 

what can i do to connect this table visions about filtering , could you give me any advice please 

[v-lili6-msft]

hi  @erhan_79 

The main problem is that you don't create a relationship between tableA and tableB.

See this document for more details:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

And since TableB is a summary table, when you create a relationship, please make the cross filter direction is "Both".

Regards,

Lin

[Anonymous]

@erhan_79  try to use reference instead duplicate  inside power query

[erhan_79]

thanks @Anonymous ;

just i wonder why reference ? what is the difference between them ? also when i add new data to main table , it is adding to duplicated table too, when it will be reference it will add new datas too ?

[az38 · Accepted solution]

@erhan_79 

you have no relationships between tables. you should define it correctly for your requirements will be met

[edhans]

I got lost in the 2nd imagine part.

Can you provide some sample data so we don't have to imagine, but can assist with real data on a real model?

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

[erhan_79]

clear