Forum Discussion
Using RELATED for tables
Hi,
In one of Udemy's example exams, there is a question about two tables - SALES and CITY DATA. They look as following:
City data
| State (citydata) | city | Population (million) |
Sales
| State (sales) | Type | Sales |
State in both tables contain similar values.
In the question you have to say whether a statement is correct or not. The following statement is, according to them, incorrect. However, I don't understand why, as the function RELATED is working on the one-side of relationships, that can import a column into the sales table:
- In the Sales table, you can write a DAX expression that uses the RELATED() function to get data from the City data table.
Can anyone explain?
Looking at the tables:
Sales is at the state granularity.
The city table is at the city granularity so each state there has multiple cities. Eg it might look like:
State City A 1 A 2 A 3 B 4 B 5 B 6 C 7 C 8 (Note City is unique but State is repeated).
You can join state to state between the tables but it will be many to many not 1 to many.
RELATED as you're aware only gets data from the 1 side of a 1 to many relationship.
2 Replies
Looking at the tables:
Sales is at the state granularity.
The city table is at the city granularity so each state there has multiple cities. Eg it might look like:
State City A 1 A 2 A 3 B 4 B 5 B 6 C 7 C 8 (Note City is unique but State is repeated).
You can join state to state between the tables but it will be many to many not 1 to many.
RELATED as you're aware only gets data from the 1 side of a 1 to many relationship.