Circular Dependency: How to solve it easily

[MrAustria]

After my inital problems and my first trials with PowerBI, I am quite satisfied with the result. Finally, I am facing one last problem - and I have not found any solution therefore: circular dependency

Table "Sales"
S = Sales
X. = Price reduction

Type	Price	Year
X1	-10	2019
X1	-5	2020
X2	-4	2020
X3	0	2019
X3	-3	2019
X3	-5	2019
S	50	2019
S	30	2020
S	40	2019
S	25	2020

Table "Price codes"

Type	Description	Maximum number of voucher
X1	General discount	50
X2	Annual discount	10
X3	Christmas discount	5

Result: when using slicer for 2020

Type	Description	Sum of reduction	Count	Average (Sum / Count)	Achieved (Count / Maximum Number of voucher)
X1	General discount	-5	1	-5	2%
X2	Annual discount	-4	1	-4	10%
X3	Christmas discount	0	0	0	0%

The calculations were being made by using Measures.
When calculation the Column "Achieved", I always get a circular dependency as a result. How can I easily solve and avoid this problem?

 

[MrAustria]

Can anyone help me?

 

[ggirf14]

What are your formulas? Where are they?

Trying to replicate what you are providing : error message on renaming table to Price codes : "space are not allowed"
Fine with Price_codes.

I see your Christmas discount calculations are all 0. This looks there may be a division by 0 on this line.

 

[MrAustria]

My formulas are in table "Sales".

Yes, the christmas discounts are all 0 when selecting Year 2020.

 

[ggirf14]

What are your formulas?

 

[MrAustria]

SumOfReduction = Calculate(Sum('Sales'[Price]);('Sales'[Price]<0);PriceCodes[Type]<>0)
Count = Calculate(Count('Sales'[Price]);'Sales'[Price]<0)
Average = Divide([SumOfReduction];[Count])
These formulas work properly, I just have a circular dependency with the following one:
Achieved = Divide([Count];[MaximumNumberOfVoucher])

How could I solve the circular dependency in the last formula?

 

[MrAustria]

Are there any solutions?