Error fetching data for this visual - summarized table

[nikkirai99]

Hi all,

I'm getting the above error message with "The query referenced column 'Member Table'[Expected Date] which depends on another column, relationship or measure that is not in a valid state.

Member Table = SUMMARIZE('Position Table','Position Table'[MemberID], 'Position Table'[MonthEnd])

Expected Date =

        CALCULATE(

            Min('Position Table'[PublishDeadline]),

            Not(ISBLANK(Position Table'[PublishDeadline])))

[PublishDeadline] is a date column. [MemberID] is a text column and [MonthEnd] is a date column. What am I missing?

[nikkirai99]

Thank you @v-fenling-msft  @AllisonKennedy  Yes, the issue was calculated columns. I changed my codes in one of the calculated columns and that issue was resolved.

[v-fenling-msft]

Thanks for AllisonKennedy's concern about this issue.

Hi, @nikkirai99 

I am glad to help you.

What is your data type? Under what operation is the problem occurring? Did you do a refresh?

Firstly, you can start by checking that the 'Position Table'[PublishDeadline] column exists and that the column name is spelled correctly in DAX. If the 'Position Table'[PublishDeadline] column does not exist or is spelled incorrectly, Power BI will not be able to find the column, resulting in an error.

Secondly, if you are doing a refresh operation with this issue, perhaps you can refer to these two Posts, hope they help:

Solved: The query referenced calculated table *** which de... - Microsoft Fabric Community

Solved: The query referenced column ****** which depends o... - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy · Accepted solution]

@nikkirai99  I just had a similar error - are any of the columns you mentioned calculated columns that are currently returning errors? The error I had was 'a table of multiple values was found when a single value was expected.' so I had to change my code to fix that invalid state column.