DAX to get text value from related table

[gvg]

Hi experts,

I need to return Product Name from a related table that has a permanent relationship through another field. I use CALCULATE. However it requires calculated expression, if I am correct. Usually SUM, MIN, MAX functions are used. But how do I get a text value from a related table, on which I can not perform such calculations, please? I am looking for something like this:

ProductName = 
    CALCULATE(
        [ProductNames],
      USERELATIONSHIP(Sales[ProductCode],Products[ProductCode]) 
    )

but this is not a valid measure. Sales and Products tables are related not via Productcode in my case.

[gvg · Accepted solution]

Well, one way out of this situation is to make a reference table. Say [ProductNames] reside in ProductCatalog table. You can make a reference table for ProductCatalog and then make the necessary relationship to that reference table.