Forum Discussion
Circular Dependency within Table for calculated column
Solution Sage
Couple of issues here.
1. Measure is evaluated in filter context, but you are trying to use it in row context calculation.
2. You can't use measure that reference table itself in the calculated column in same table.
There are couple of ways to work around it, that I can think of.
1. Create summarized table using dax. Create relationship, perform your calculation based on it.
2. Add your calculated column(s) using "M" in query editor.
I prefer method 2. Especially when calculated column(s) are in Fact table.
How do I add my calculated columns?
- Chihiro
Without sample data, hard to help you. I'd recommend uploading pbix with sample model (using dummy data, but with same structure) to OneDrive or some other service and share a link here.
It makes it so much easier to help you, when we don't have to recreate/imagine the model you are working with.
Here's the simplified version of the data:
https://drive.google.com/open?id=1gvm0dxSIkp3iDj9AdyKLGSTY8vTSi8VX