Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Hi Team,
I am stuck with some calculation part in my reports that is the calcuation of measure and column
i have a one measure and another is column so need to devide a measure and the column how can it be possible and both are in same table if i can calculate like this
Result = DIVIDE([Measure], CALCULATE(SUM(Table[Column])),0)
it will also give an error of circular dependancy Please let me know if anyone have the solution to this.
Thanks in Advance
HIi @kiran123 ,
Could you show me the DAX formula of the measure and the calculated column?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 12 | |
| 10 | |
| 10 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 46 | |
| 34 | |
| 27 | |
| 20 | |
| 19 |