Circular Dependency help neeed

[jonbox]

Hi,

I have a circular dependency error, it was working and i am not sure of the problem.

i added an extra column in my table for "Compliance" but my formula's shouldnt care about that considering i just need to determine the sum of all columns in the "Sum score" column and divide by another column "COUNT filled tabs".

Cpmpliance:

Sum Score:

Hopefully someone can see what i can't! no resources i've looked at make it clear why there's an issue...

Thanks! 

[v-jayw-msft · Accepted solution]

Hi @jonbox ,

Try this formula.

column = 
var sum_score = calculate(sum(column1)+sum(column2)+sum(column3)+...etc ,filter(table,[status] = "active"))
return
IF('TABLE APP MNGMNT 01'[Status]="N/A" || 'TABLE APP MNGMNT 01'[Status]="REMOVED" || ISBLANK('TABLE APP MNGMNT 01'[COUNT filled tabs]),BLANK(),divide(sum_score,'TABLE APP MNGMNT 01'[COUNT filled tabs])

Best Regards,

Jay

[amitchandak]

@jonbox , if you creating a column and using the a column, which is already coming from that then you can get

A uses B and D

C Use A

D used C

Where both D and A use each other

If you try to use a measure in a column

Also, check

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Share formula in text format to check

[jonbox]

Hi,

Thanks for the swift response, always appreciated.

I did try to use a measure instead but still the same issue...

Also read through the linked document, helpful but still can't work it out!

See my forumlas below:

Compliance = IF('TABLE APP MNGMNT 01'[Status]="N/A" || 'TABLE APP MNGMNT 01'[Status]="REMOVED" ,BLANK(),(IF( ISBLANK('TABLE APP MNGMNT 01'[COUNT filled tabs]),BLANK(),                                                       
DIVIDE('TABLE APP MNGMNT 01'[Sum score],'TABLE APP MNGMNT 01'[COUNT filled tabs]))))     

Sum score = IF('TABLE APP MNGMNT 01'[Status]="ACTIVE",
   CALCULATE(SUM('TABLE APP MNGMNT 01'[BIA])+SUM('TABLE APP MNGMNT 01'[Data Classification2])+SUM('TABLE APP MNGMNT 01'[CSV (Ov) - Copy])+SUM('TABLE APP MNGMNT 01'[Access Management])+sum('TABLE APP MNGMNT 01'[MEGA])+SUM('TABLE APP MNGMNT 01'[Application Documentation])+SUM('TABLE APP MNGMNT 01'[Transactional Log])+SUM('TABLE APP MNGMNT 01'[License Management])+SUM('TABLE APP MNGMNT 01'[Record Retention2])+SUM('TABLE APP MNGMNT 01'[ACP in Archer])+SUM('TABLE APP MNGMNT 01'[iRisk e CSC])+SUM('TABLE APP MNGMNT 01'[Support Model])))