Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

relationship tables explaining

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?????????????



 

Show and Tell
Tips and Tricks

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous, Ideally in table B you should do like

    new column =

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

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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.