topic Re: Using RELATED for tables in DAX Commands and Tips

Using RELATED for tables

Anonymous — Sun, 09 Jan 2022 14:57:55 GMT

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?

Re: Using RELATED for tables

bcdobbs — Sun, 09 Jan 2022 15:45:32 GMT

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.

Re: Using RELATED for tables

Anonymous — Sun, 09 Jan 2022 21:06:05 GMT

Thanks! I understand it now.