Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure divide

I want to calculate the rate = division (Total Processing, connected time) The result is wrong, how to do?
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi @Hendd,

     

    The DIVIDE function performs safe division and can return an alternate result or a null value when divided by zero. Its syntax format is DIVIDE ( <numerator>, <denominator>, [<alternate result>] ).

     

    Here are my steps you can follow:

    (1)This is my test data.

    (2)We can create a measure: “rate”.

     

     

    rate = DIVIDE( SUM('Table'[Total Processing] ),SUM('Table'[connected time]) , "error")

     

     

    (3)Then the result is as follows.

    Can you give me some sample data and your expected results so that I can better help you solve your problem?

     

    Best Regards,

    Neeko Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi @Hendd,

 

The DIVIDE function performs safe division and can return an alternate result or a null value when divided by zero. Its syntax format is DIVIDE ( <numerator>, <denominator>, [<alternate result>] ).

 

Here are my steps you can follow:

(1)This is my test data.

(2)We can create a measure: “rate”.

 

 

rate = DIVIDE( SUM('Table'[Total Processing] ),SUM('Table'[connected time]) , "error")

 

 

(3)Then the result is as follows.

Can you give me some sample data and your expected results so that I can better help you solve your problem?

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.