I am trying to capture some information from a Matrix.
I can successfully create a new column for one of the figures i need, but when I try and create another one i get the circular dependency error and I don't know what to do or how to correct it:
First new column:
CurBounce = IF(View_EmailMetricsUnionNatural[Metric Name] = "# of bounces",View_EmailMetricsUnionNatural[Cur Mo Cur Yr],0)
With this formula i can successfully grab the Cur Mo Cu Yr value in this example the number 3. I am displaying the column so i can see it worked.
Now if I try and create another New Column....using the same criteria, but trying to grab 2181 from '# emails sent', I get the Dependency error. Same code just a different Metric Name.
CurEmailsSent = IF(View_EmailMetricsUnionNatural[Metric Name] = "# emails sent",View_EmailMetricsUnionNatural[Cur Mo Cur Yr],0)
I don't know if it is worth mentioning, but if I delete the first new column (CrBounce) and create the second new column frist, then it creates the '# emails sent' successfully and i get the error when trying to create the second new column for CurBounce.
Esentially i need think of a way where i can make this calculation: 3 / 2181 *100 to get a percentage that I can display perhaps in a Card visual. Or "# of bounces" / "# emails sent" * 100
I have tried doing this in a New Measure but have not been successful with the syntax.
I am not even sure if what I want to do should be a new measure or a new column?
Unfortunately i don't have a lot of experience with power bi (yet). So if you can include examples that would be helpful.
A little weird! Could you share a sample pbix file which can reproduce the issue? So that we can help further investigate on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.