Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?????????????
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
Best Regards
Lucien
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.
Proud to be a Super User!
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.
@Anonymous, Ideally in table B you should do like
new column =
maxx(relatedtable(TableA), TableA[Value])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |