topic Re: Error when using Related function in DAX Commands and Tips

Error when using Related function

BBK — Mon, 05 Feb 2024 06:21:26 GMT

Hi. A newbie here. Would appreciate any help regarding this error.

I have been adding a new column in table named "DimSalesTerritory" to reflect the count of sales based on another table named "FactInternetSales". But using the "Related" function gives me an error. I have attached screenshots of the error, as well as the relationship diagram of the tables.

Thank you.

Re: Error when using Related function

FreemanZ — Mon, 05 Feb 2024 06:13:24 GMT

hi BBK ,

try RELATEDTABLE, instead of RELATED.

Re: Error when using Related function

BBK — Mon, 05 Feb 2024 06:32:21 GMT

Thank you! It works fine!