Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
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
@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])))
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |