Table found and not found in the same measure, if variables used?

[SevsBo]

I have a table created within the Power BI report, called "Ultimate_Calendar" that is linked with bidirectional relationship to table "Main_Data". "Main_Data" comes from a live connection to a semantic model.

I am building a measure using time intelligence, and the first part works perfectly fine, but when I try to build a condition using an IF statement, Ultimate Calendar is no longer found.

What am I doing wrong?

[Demert · Accepted solution]

Hi @SevsBo ,

In an IF statement you can't just call the table name and column to check if the statement is true or not. Try using max,selectedvalue,min,... instead to call the table and column.