Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
SevsBo
Helper V
Helper V

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

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?

 

SevsBo_0-1750685044521.png

 

1 ACCEPTED SOLUTION
Demert
Resolver III
Resolver III

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. 

View solution in original post

1 REPLY 1
Demert
Resolver III
Resolver III

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. 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors