Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Related function not working

Hello everyone, I have looked at many posts related to this issue but have not been able to find a solution.    We have a 1:* relationship between 2 tables. The table on the many side of the relat...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Todd,

Thank you very much for this information. Here are the details of the relationship:

 

So I am trying to create the calculated column in the CVCS table. When I just try to do a simple RELATED() function without any nested IFs, I still get an error: 

I'm not too sure where to go from here. Per the original designer of the report, we need to use DirectQuery as it is a HANA data source so they do not want to import the data. However, I have been thinking of trying to import the data on my own to see if that does fix the issue but it will be a bigger change. 

 

ToddChitt's avatar
ToddChitt
Super User
5 years ago

Since Power BI is an in-memory tool, when you create a calculated column like you are trying (and it looks like everything is done correctly here) then Power BI will go through every record in the table, resolve that function to get a value, then push that resulting data up into memory.

But since the table it is goin against is Direct Query (is that right, or is it the other way around?) it may NOT be able to resolve the function. 

 

Try a simple test with both tables, with limited data, doing Import. Then try the same data but with Direct Query. The results of those tests should tell you something.