Forum Discussion

vaz19's avatar
vaz19
New Member
4 years ago
Solved

Circular Dependency error

Hi all, I'd like to create two new columns, but I get an error "circular dependency was detected: DailyEntry[Intensity (%)], DailyEntry[Volume (%)], DailyEntry[Intensity (%)]"   The first column...
Need Help
Tips and Tricks
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi vaz19 ,

    If there is only one data table in the report, you need to set a key column for the table and then use removefilters() in the two calculated columns:

    Column = 
VAR TD = [TD_Game%]
VAR RESULT = TD / 4
RETURN
    CALCULATE ( RESULT, REMOVEFILTERS ( 'Table'[Column 2] ) )

Column 2 = 
VAR td = [TD_Game%]
VAR result = td / 4
RETURN
    CALCULATE ( result, REMOVEFILTERS ( 'Table'[Column] ) )

     

    Please refer this blog: Avoiding-circular-dependency-errors-in-dax 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi vaz19 ,

If there is only one data table in the report, you need to set a key column for the table and then use removefilters() in the two calculated columns:

Column = 
VAR TD = [TD_Game%]
VAR RESULT = TD / 4
RETURN
    CALCULATE ( RESULT, REMOVEFILTERS ( 'Table'[Column 2] ) )

Column 2 = 
VAR td = [TD_Game%]
VAR result = td / 4
RETURN
    CALCULATE ( result, REMOVEFILTERS ( 'Table'[Column] ) )

 

Please refer this blog: Avoiding-circular-dependency-errors-in-dax 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.