Forum Discussion

nikkirai99's avatar
nikkirai99
Frequent Visitor
1 year ago
Solved

Error fetching data for this visual - summarized table

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?
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    1 year ago

    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.

3 Replies

  • nikkirai99's avatar
    nikkirai99
    Frequent Visitor
    1 year ago

    Thank you Anonymous  AllisonKennedy  Yes, the issue was calculated columns. I changed my codes in one of the calculated columns and that issue was resolved.

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.