relationship tables explaining

[Anonymous]

Hi, 

I was wondering about the following relationship between 2 or more tables.
Example: I have 2 tables that has the following relationship-->

In table B have a calculated column that shows the max value for each of the Item in table A and it shows the correct max value from table A for the Items :

How is the max value from table A is calculated when there is only a 1 directional relationship/filter from table B to A, is there a hidden relationship back from A to B, ie values from A goes to B???

Could someone explain this to me?????????????

[v-luwang-msft]

Hi @Anonymous ,

If you want to learn more details ,refer the following articles.It is very detailed and useful, and I hope it will help you.

bidirectional-relationships-and-ambiguity-in-dax

Bi-directional relationship guidance

Best Regards

Lucien

[FarhanAhmed]

Actually when you put CALCULATE in expression it changes the Evaluation context of the expression. It changes it to rows that it belongs to otherwise if you put MAX(Column) only without specifying the CALCULATE the whole table will be evaluated in calculated column.

[Anonymous]

Great!

Still, how does the max value flow from table A to B when there is no relationship flowing from A to B ---> with just a simple calculate(max(table A(value)). At least with the MAXX function it is easier to understand that it is iterating through table A to find max value.

 

[amitchandak]

@Anonymous, Ideally in table B you should do like

new column =

maxx(relatedtable(TableA), TableA[Value])