Create a new table (from existing table) inherits relationships without show in relationship visu...

[pade]

When I crated a new table in Power bi from an existing table, it looks like if the new table inherits the relationships the parent table had to other tables. This might be by design, but then the relationship should also be visable in the relationship view (and it's not)

The easiest way to create a new table is to just write the formula

• Table2='Table1'

As I can see, 'Table2' then is effected by filters applied to 'Table1'

This might be by design, and the tool then needs to be updated to show the relationship in the relationship view

A slightly more vague method is to create the new table using a formula, e.g.

• Table3=calculatetable('Table1')
• Table4=calculatetable('Table1', 'Table1[column1]="testing")
• Table5=filter('Table1', 'Table1[column1]="testing")
• Table6=crossjoin('Table1', 'TableX')
• summarize(...)
• etc

I haven't checked what formulas are breaking the inheritance of the relationship and if they do, but this have to be documented and visable in the relationship visulizer

[v-qiuyu-msft]

Thanks @Anonymous for detail explanation. 

@pade I will close this thread as you suggested. 

Best Regards,
Qiuyun Yu 

[pade]

Thanks, and as I said before. The fault was on my side, så please close this thread

[Anonymous]

Hi @pade @v-qiuyu-msft

Corrected Statement : The new table will not get calculated after all the filters (applied through either relationships or report filters) to its parent table because the new calculated table will get calculated during the processing time of the model and then it acts as an Independent physical table from there.

Check out the attached screenshot where the filter applied to parent table doesn't effect the new calculated table.

[v-qiuyu-msft]

Hi @pade@Anonymous,

What do you mean about "As I can see, 'Table2' then is effected by filters applied to 'Table1'" and "The new table will get calculated after all the filters (applied through either relationships or report filters) to its parent table."? 

Would you please share some screenshot or pbix file to clarify the issue? 

Best Regards,
Qiuyun Yu 

[pade]

You're totaly correct @Anonymous. Tested in a smaller environment and it's like you said. Need to go back to my original file and fix the "real" problem

[Anonymous · Accepted solution]

I think, The new table doesn't inherits the relationships the parent table had to other tables but it's just obvious to depend on its parent table while new table gets calculated. The new table will get calculated after all the filters (applied through either relationships or report filters) to its parent table.