cancel
Showing results 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.

Helper II

## Measures

Good morning everyone from Sierra Leone, West Africa.

Given these two measures:

GDP per Capita2 = [GDP]/[Population]
GDP par Capita = DIVIDE(Indicators[GDP],Indicators[Population],0)
The GDP and Population are measures, both of them captured in the same column (Indicator) of a table called Indicators but, with different codes.
These two measures generate the same results in a visual.
Is there a difference between these two measures and would I be correct to use either in similar situations.
How I wish I could send the .pbix file to make things easy. I am working on it. Hope my question makes sense. Thanks.
1 ACCEPTED SOLUTION
Resolver III

Hii @Alusine_Kamara
Error handling is the major difference between the with or without divide function,

1. The "Divide"
function is designed to handle division by zero errors. helping to avoid potential errors in your calculations.
2. The division operator ("/") is more concise for simple division operations without the need for explicit error handling.

mes1 = DIVIDE(1, 0, 0)   //Returns 0 if the divisor is 0
mes2 = 1 / 0   //Results in an error

This is useful means mark as a solution and hit the kudo

Thank you

2 REPLIES 2
Helper II

Thank you very much.

Resolver III

Hii @Alusine_Kamara
Error handling is the major difference between the with or without divide function,

1. The "Divide"
function is designed to handle division by zero errors. helping to avoid potential errors in your calculations.
2. The division operator ("/") is more concise for simple division operations without the need for explicit error handling.

mes1 = DIVIDE(1, 0, 0)   //Returns 0 if the divisor is 0
mes2 = 1 / 0   //Results in an error

This is useful means mark as a solution and hit the kudo

Thank you

Announcements

#### 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

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors