Forum Discussion

Joan_Roig's avatar
Joan_Roig
Regular Visitor
1 year ago
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...
  • v-venuppu's avatar
    1 year ago

    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.