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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
slhangen
Helper II
Helper II

Input Table not found

I am trying to create a new table using SUMMARIZE but I am getting an error saying input table cannot be found.

 

I have a created table called SEM 1 Failures that is simply a summarized, filtered table from table

Course Failure Count SEM 1 FAILURES = SUMMARIZECOLUMNS('Course Failure Count'[Title],'Course Failure Count'[Student], 'Course Failure Count'[Course Failures], 'Course Failure Count'[SEMESTER],filter('Course Failure Count','Course Failure Count'[SEMESTER]="SEM 1"))

 

SEM 1 FAILURES DOES appear as usable table in formula bar

 

I have a created table called SEM 2 Failures that is also simply a summarized, filtered table from table

 

Course Failure Count SEM 2 FAILURES = SUMMARIZECOLUMNS('Course Failure Count'[Title],'Course Failure Count'[Student], 'Course Failure Count'[Course Failures], 'Course Failure Count'[SEMESTER],filter('Course Failure Count','Course Failure Count'[SEMESTER]="SEM 2"))

 

The two tables are exactly the same except one is filtered for SEM 1 and the other for SEM 2

 

SEM 2 FAILURES does NOT appear as usable table in formula bar,

Get error The column 'Course Failures' specified in the 'SUMMARIZE' function was not found in the input table.

 

This is driving me crazy, please HELP!!!

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @slhangen 

I tested both of your "SEM 1 FAILURES" and "SEM 2 FAILURES" formulas to create a calcualted table and they both worked well without error. Check if there is any spelling typo in table name or column name in formulas.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

View solution in original post

3 REPLIES 3
slhangen
Helper II
Helper II

It seems I didn't create the relationship for the second table. SMH!

Been a turbulent, busy week. Thank you so much for following up and sorry I wasted your time. 

I am sure I will be needing your help again soon, LOL

It's ok. Seems the original formula doesn't use two tables in it.

v-jingzhang
Community Support
Community Support

Hi @slhangen 

I tested both of your "SEM 1 FAILURES" and "SEM 2 FAILURES" formulas to create a calcualted table and they both worked well without error. Check if there is any spelling typo in table name or column name in formulas.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.