Calculation Error in Measure

[Anonymous]

Hello Experts,

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

Regards,

Ajay

[Anonymous]

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

[v-xiaotang]

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.

[ryan_mayu]

@Anonymous 

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

[Anonymous]

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]

@Anonymous 

could you pls provide the pbix file?