Calculate simple DAX division on a new column

[nanty]

Hello, basically I'm trying to create a new  column with a simple division, but I'm stuck on this. Does the DIVIDE function only work with measures?

This is the DAX expression that I'm using: Division Column = divide(sum([Column A]),sum([Column B]),0)

I need the result to be shown on a column so I can later use  it on a PERCENTILE.EXC expression, but I keep getting this error message: 

I get an error message saying: "A circular dependency was detected: [Column A], [Division Column], [Column B]"

Any help would be highly appreciated!

Thank you in advance,

[RMDNA]

@nanty,

The error "A circular dependency was detected: [Column A], [Division Column], [Column B]" indicates an error with your table relationships, not necessarily an issue with your DAX syntax.

Reevaluate your table relationships and find the circular depedency, and that should solve this issue.

[nanty]

Hello @RMDNA!

Thank you for your reply. I changed the DAX formula I was using for the other columns and that seemed to solve the error message (those  two columns count the number of registries there are in several columns, count them as 1 and then sum them up depending on another column value). Nonetheless, when I calculate the division (both manually with / symbol and with the DIVIDE function), I get a very different result than it is supposed to. For example,dividing the first line under "Registros x agente" between the "Reg reiterados - IM" value would have to result in 3.3 and it is giving me 14 and 19 on each kind of function I am using:

[Ashish_Mathur]

Hi,

Wrap the numerator and the denominator in the SUM() function.

Hope this helps.

[nanty]

Hello, basically I'm trying to create a new  column with a simple division, but I'm stuck on this. Does the DIVIDE function only work with measures?

This is the DAX expression that I'm using: Division Column = divide(sum([Column A]),sum([Column B]),0)

I need the result to be shown on a column so I can later use  it on a PERCENTILE.EXC expression, but I keep getting this error message: 

I get an error message saying: "A circular dependency was detected: [Column A], [Division Column], [Column B]"

Any help would be highly appreciated!

Thank you in advance,

[RMDNA]

@nanty,

See my answer in your duplicate thread.