Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to subtract two calculated columns. I tried a simple subtraction without the Calculate and Sum as well and that gave the same circular reference error.
Solved! Go to Solution.
Resolved it by creating a measure for Absent and Present. Oddly, when I tried to delete the calculated column for Absent, the measures stopped working eventhough they no longer referenced the calculated absent column. Just happy I now have an accurate measure.
Can you try this please...
Present = Instructional_Date_Calendar[Enrolled] - Instructional_Date_Calendar[Absent]
Any sample data for replicating your error will be helpful...
Proud to be a PBI Community Champion
Here is a screenshot of the formula you suggested. I attempted to remove some inactive relationships to see if that was the problem. That had no effect. I hope you can see some of the data on this screenshot. I really think the error has something to do with the Enrolled column being a calculated column that is based on a table that is a union of two other tables that have no relationships established. Could that be it?
@lawsonbe Still not clear, please post what is your actual input data look like and what are the calculated columns you created along with their expressions used. Anyway, you already posted what you want to see as output...
Proud to be a PBI Community Champion
Resolved it by creating a measure for Absent and Present. Oddly, when I tried to delete the calculated column for Absent, the measures stopped working eventhough they no longer referenced the calculated absent column. Just happy I now have an accurate measure.
Hi @lawsonbe,
It's pleasant that your problem has been solved, could you please mark your reply as Answered?
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |