simply put I have 2 tables, one containing number of items shipped, and a dim table containing cubic meters (CBM) of each product. They have an active relationship set up based on a product ID, but when I want to use the CBM values in a measure using the related function, it returns an error saying the tables are not related. With calculated column, the exact same DAX code works just fine, but I would like to avoid using a column due to data size. What is the reason it is not working with a measure?
"I always try to avoid using calculated columns unless the desired outcome is a categorial value or I want to use it for filtering." I don't know what is your data size, but i do use calculated columns whenver possible, as while they slow down the load of the model, they make it much faster in the use. There are some models that I make that CANNOT work without pre-calculated columns, measures make extremely slow.
But anyway, measures and CC serves different uses. *In this case* it looks like a CC is the best method. And RELATED works only in row context: