Forum Discussion

Alusine_Kamara's avatar
2 years ago
Solved

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.
  • 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

  • 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