Forum Discussion

Pier8891's avatar
Pier8891
Frequent Visitor
2 years ago

Need Help Resolving Circular Dependency in Power BI for Average Margin Per Workshop Calculation

  Hi everyone,   I'm new to using Power BI and I've run into a circular dependency issue that I'm struggling to resolve. I'm working on a report where I need to calculate the average margin ...
Need Help
StrategicSavvy's avatar
StrategicSavvy
Resolver II
2 years ago

hi Pier8891 ,

If I see correct you try add calculated column to your table to perform divison of sum of one measure over another. In this case you dont need to use RELATEDTABLE function as this is within same table. 

Try this formula:

Margen Medio per Workshop =
DIVIDE(
	SUMX('UNION VENTAS 19-21', [Beneficio neto por producto]),
	SUMX('UNION VENTAS 19-21', [TOTAL VENTA])
)

 

 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: www.linkedin.com/in/lukasz-kozdron