Forum Discussion
Model loading error
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.
Community SupportHi Joan_Roig ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hello, it's clear I can't solve this problem. The model has 80 measures, and using DAX View, I located three of them with the same error. I can't modify any measure because when the model tries to update, it fails again and doesn't save the changes.
I also opened the file with Tabular Editor and checked what was happening on the server with SQL Server Profiler. In both cases, errors appeared, but none of them clarified the actual problem. It's obvious this issue is beyond my current knowledge.
It looks like I'll have to rebuild the file from scratch, which will be a big job
