Forum Discussion
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], View_EmailMetricsUnionNatural[CurNumBounces].
Here is the Formula:
CurNumBounces = IF(View_EmailMetricsUnionNatural[Metric Name] = "# of Bounces",View_EmailMetricsUnionNatural[Cur Mo Cur Yr],0)
Do you know what it is saying and how can I fix it?
thanks
Also is there a power bi site that gives lots of examples?
It seems I can find sites that list all of the functions but are void of good samples.
10 Replies
- Hi strangerMike,
Try this change to your measure:
CurEmailsSent = IF(
Contains(View_EmailMetricsUnionNatural[Metric Name], "# emails sent"),
[Cur Mo Cur Yr],
0
)
Regards,
MFelixThanks 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!
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 .......
Also I tried your example for a new measure and i got this error:
Too few arguments were passed to the CONTAINS function. The minimum argument count for the function is 3.
Thanks
