RELATED for cross-table values in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the DAX function RELATED do in Power BI?

RELATED fetches a value from a related table based on an existing relationship. It helps you bring data from one table into another when they are connected.

intermediate

How does RELATED differ from LOOKUPVALUE in Power BI?

RELATED uses existing relationships between tables to get values, while LOOKUPVALUE searches for values without needing a relationship but can be slower and more complex.

beginner

Can RELATED be used if there is no relationship between tables?

No. RELATED requires a defined relationship between tables in the data model to work correctly.

beginner

Write a simple example of RELATED to get the 'CategoryName' from a 'Categories' table into a 'Products' table.

CategoryName = RELATED(Categories[CategoryName])

intermediate

Why is using RELATED considered efficient in Power BI?

Because it uses existing relationships, RELATED is optimized and faster than searching values manually. It keeps your model clean and easy to understand.

What is required for the RELATED function to work in Power BI?

A A relationship between tables

B A calculated column

C A filter on the table

D A measure in the table

RELATED needs a defined relationship between tables to fetch values.

Which DAX function is best when you want to get a value from a related table using an existing relationship?

A RELATED

B FILTER

C SUMX

D LOOKUPVALUE

RELATED uses existing relationships to get values efficiently.

If there is no relationship between tables, what will RELATED return?

A The first value found

B Blank

C An error

D Zero

RELATED requires a relationship; without it, it returns an error.

Which of these is a correct use of RELATED to get 'City' from a 'Customers' table?

A City = RELATED(Sales[City])

B City = RELATED(Orders[City])

C City = RELATED(Products[City])

D City = RELATED(Customers[City])

You use RELATED with the table that has the column you want, here 'Customers'.

Why might you choose RELATED over LOOKUPVALUE?

A LOOKUPVALUE is faster

B RELATED is faster and uses relationships

C RELATED works without relationships

D LOOKUPVALUE is simpler

RELATED is optimized for existing relationships and usually faster.

Explain how the RELATED function works in Power BI and when you would use it.

Think about how tables connect in your data model.

Describe a scenario where RELATED would not work and what you could do instead.

What happens if tables are not linked?