Modify DAX Formula for Direct Query???

[Anonymous]

Hi, I had to change my data load from import to direct query, and because of that a DAX calc column no longer works (see error screenshot). Is there an alternative formula that would work? There are 4 other calc columns that did not error out, only this one. Thanks!

[Anonymous · Accepted solution]

Creating a measure in the table used for the visual works, ie.

TFB Rank = MIN(bi vwTFBN1PriorityList[[Overall Stack Rank]) 

[lbendlin]

Needs more details?  Are these fields related through the data model?

[Anonymous]

Ok, the reason for creating the DAX in the 1st place is because the PBI visual (a table) needs both PR Code and TFB Rank. But, TFB Rank field exists in a separate table than PR code (because they are in separate SQL tables). There is a many-many relationship between the 2 tables, but if the PR code doesn't exist in the TFB Rank table, then it won't show the project at all, whereas the PBI visual intention is to show ALL projects, even those that don't exist in the TFB rank table, which is why that DAX code was created. Does this make sense?