Forum Discussion
Circular Dependency within Table for calculated column
How do I add my calculated columns?
Solution SageWithout 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
Any idea on how to solve this?
- Chihiro
Try using it as measure instead of calculated column.
With your sample it returns Group1 for all but the last row (which shows Other as MarginClass & MarginPL show NaN).
Not sure if this is correct result or not.
I can't use measures since I need to use these groups as a visualization axis.