Forum Discussion
Utterly perplexed why I'm getting error messages when refreshing this model
- 1 month ago
Hi masplin
Please check the below points.
IncomeGroup[Min]/[Max] call the measures [Total Population] and [Av annual Net Income], which scan all of MSOA_Mapping including [Income Group]/[Income Tgt], which are built from Min/Max. That loop is what breaks the rebuild.Three quick edits fix it:
1. Add a plain column: MSOA Population = CALCULATE ( SUM ( 'Age by MSOA'[Population] ), 'Age by MSOA'[Year] = 2024 )
2. In Min and Max, replace the AVIncome VAR (drop the measures):
VAR AVIncome =
DIVIDE (
SUMX ( MSOA_Mapping, MSOA_Mapping[MSOA Population] * MSOA_Mapping[Net annual income after housing costs (£)] ),
SUMX ( MSOA_Mapping, MSOA_Mapping[MSOA Population] ),
BLANK ()
)
Keep the rest of Min/Max unchanged same result.
3. Set MSOA_Mapping[LA Name] → Property[LA_name] to single-direction (keep it Active).Note: never call a measure inside a calculated column on a table that measure scans.
Make those three changes and refresh sorted.
Thank you.
Ok I have put al lthe supporting files in one folder here Source Files .
I editted the query so there is a parameter you can change to point it at wherever you down load the source files to so hopefully it will all work.
much appreciated any thoughts
- FBergamaschi1 month agoSuper User
OK I am on it, downloading
you said you changed the query with the parameter but I do not see the updated pbix on the shared link you just sent, can you share the new pbix as well?
Thanks