Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
kiran123
Frequent Visitor

Devide

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

 

 

 

1 REPLY 1
v-lionel-msft
Community Support
Community Support

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors