Input Table not found

[slhangen]

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!!!

[slhangen]

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

[v-jingzhang]

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

[v-jingzhang · Accepted solution]

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.