Forum Discussion

strangerMike's avatar
strangerMike
Helper II
9 years ago

DAX Syntax

Hello,   I am trying to create a New Column,  but I get this error:   A circular dependency was detected: View_EmailMetricsUnionNatural[CurNumBounces], View_EmailMetricsUnionNatural[CurEmailsSent...
Need Help
strangerMike's avatar
strangerMike
Helper II
9 years ago

Thanks MFelix,

 

Please reread the post (I edited it).

I was successful creating a new Column instead of a measure.

 

However I tried creating another new column and I received the error you see in the post.

 

Any ideas? Thanks

 

PS. after reading about measures, perhaps the new column is not the way to go!  I am confused!

CahabaData's avatar
CahabaData
Memorable Member
9 years ago

well circular dependency is when 1 calculated field requires another which in turn is dependent upon the original - or - an equivalent of that via the joins between tables - or - an IF/SWITCH statement with the same issue

 

not sure exactly which phrase we're discussing .......

  • strangerMike's avatar
    strangerMike
    Helper II
    9 years ago

    Thanks CahabaData

     

    So this is the formula causing the dependency issue:

     

    CurNumBounces = IF(View_EmailMetricsUnionNatural[Metric Name] = "# of bounces",View_EmailMetricsUnionNatural[Cur Mo Cur Yr],0)

     

    The odd thing is I just created this one without any errors:

    CurEmailsSent = IF(View_EmailMetricsUnionNatural[Metric Name] = "# emails sent",View_EmailMetricsUnionNatural[Cur Mo Cur Yr],0)

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi strangerMike,

      Please check your data according to CahabaData posted. The syntax of your formula is right. Just like [CurEmailsSent] measure, it works fine.

      Thanks,
      Angelia

      • strangerMike's avatar
        strangerMike
        Helper II
        9 years ago

        Hi Angelia

        I looked through the article about the circular dependancy.

        I went back through the queries and included a RecId which is a unique identifier. I was hopeing this would satisfy

        the:  "You can manually set the property of Row Identifier for ProductKey to TRUE...." is this something that takes place in Desktop?

        When I 'Edit Query', is there something there i need to turn on to have power bi recognize it? 

         

        Assuming the addition of RecId might help, I tried to create the second new column and I still get the Circ. Dependency error.

        Is there something else i need to do?

         

         

        Col1 = IF(View_EmailMetricsUnionNatural[Metric Name] = "# of bounces",View_EmailMetricsUnionNatural[Cur Mo Cur Yr])

        Success

         

        Col 2= IF(View_EmailMetricsUnionNatural[Metric Name] = "# emails sent",View_EmailMetricsUnionNatural[Cur Mo Cur Yr]) 

        Fails

         

        Thank you