Forum Discussion
Solved
Model loading error
Hi, With any change in the computer or data source, today the data isn't loading into the model, PowerQuery it seems works and update well, but at the end of the model update process I get this erro...
Hi Joan_Roig ,
Thank you for your Response..!!
This happens when DAX tries to evaluate MAX() in a context where multiple values exist, and it can't determine which single value to use-especially when MAX() is used directly in a filter argument or inside CALCULATE.
Using a variable makes the logic stable and avoids ambiguity errors during evaluation.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly.
Thank you.
Jai-Rathinavel
Super User
Super UserHi Joan_Roig
1. Please download the model from Service and refresh it on Desktop and Debug the error.
2. Got to Power Query View and check individual queries for errors and fix it.