Forum Discussion
Circular Dependency help neeed
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!
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
3 Replies
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
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])))
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
