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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Ankit_Keshri08
Frequent Visitor

columns are not populating while using IF Statement

Hi 

am using IF statement but for particular table 'Section'

but column name are not populating only created measure are reflecting below snapshot as you can see

can please someone help me on this 

 

Ankit_Keshri08_0-1674103401129.png

 

4 REPLIES 4
Mahesh0016
Super User
Super User

@Ankit_Keshri08 

 

>> if you want use column directly in IF statement so you can only use in calculated column in not measure if you use in measure use aggregated function in column.

 

@Ankit_Keshri08 Thank you!

hi @Mahesh0016  ,

 

below are the logic am trying to use in power BI 

-----

Subscriber Status =
 IF(Section[connection_post] >= 50 , 0)

---

section table having connection_post column but while writing this logic why it's saying that this column is not able to find ???

As you can see below snapshot i have marked

can you please check 

thank you 

 

Ankit_Keshri08_0-1674108640121.png

 

 

@Ankit_Keshri08  Please check column spell.

hi @Mahesh0016 

 ,

yes after that also same issue 

Ankit_Keshri08_0-1674109100155.png

means after selecting the table itself column dropdown should come but not showing ,

 

if i will any aggregation function the column dropdown will come

as below you can see all columns are highlighting by selecting table name 

Ankit_Keshri08_1-1674109205261.png

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors