Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculation Error in Measure

Hello Experts,

 

I am facing the below issue, Could anyone please help me out.

 

 

 

Regards,

Ajay

Need Help
Show and Tell
Tips and Tricks

5 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    Anonymous 

    maybe you can remove the CALCULATE and have a try again.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi ryan_mayu 

       

      Thanks for the immediate response.!

      Tried removing Calculate but still it is the same issue. 

       

       

      I am looking for the SUM of average measure as shown below.

       

       

      Regards,

      Ajay

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        5 years ago

        Anonymous 

        could you pls provide the pbix file?

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Anonymous 

    you need to rewrite the measure [Total Variance (Avg)] according to the error message, could you share your sample file & expected result? you can remove raw data and replace it with fake data. 

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello ryan_mayu, 

     

    I am able to calculate formula for sum of average of Actual Amount field and it was working fine. I tried to create the formula in the same way for variance and over variance fields but facing circular dependancy error.


    Please find the attached sample file and help me with some suggestions in resolving the error.

     

    Sample File 

     

    Regards,

    Ajay