Forum Discussion

mpicca13's avatar
mpicca13
Icon for Resolver IV rankResolver IV
6 years ago
Solved

Can't Apply Query Changes - The model doesn't have a named expression <Measure Table>

When trying to refresh my report I get the following error:   Average Measures The model doesn't have a named expression named Average Measures.   Average Measures is a Measure Table with no c...
Data Modeling
  • mpicca13's avatar
    mpicca13
    6 years ago

    Update: I have resolved my own issue, one of my measures in my measure table was trying to calculate a column from a dimension table which had recently changed data types from int to string. I changed the data type back to int this fixed the issue.

RCA's avatar
RCA
Regular Visitor
6 years ago
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

So I did the same as you suggested and added the Column where I defined it as:

Column = BLANK()
 
I hid the column and then tried to refresh. I get the same error when I attempt to refresh:
 
The irony is that this model came as  a download from PBI service. I didn't modify anything. What has happened here? Any ideas how to fix?
 
Thanks