Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Divide function giving different results

Hi All,

 

In first screenshot What i want is and in second sceenshot what i am getting is ,

How can i resilve it.

 

What i am getting

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Anonymous,

     

    Is your table like this?

    I created a measure but didn't meet the error:

    Measure 2 = 
VAR x = 
COUNTX(
    FILTER(
        Sheet9,
        [Status] = 2
    ),
    [Status]
)
VAR y = 
COUNTAX(
    Sheet9,
    Sheet9[Status POT]
)
RETURN
DIVIDE(
    y,
    x
)

    The error is very strange.

     

    Why did you add filters on this visual?


    Maybe you can remove the filters , then, try it again.

     

     

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Missed needed screenshot:

    • v-lionel-msft's avatar
      v-lionel-msft
      Community Support
      6 years ago

      Hi Anonymous ,

      You want to use "DIVIDE" function to calculate the result, right?

      Is the right result 0.79?

      Maybe you can try this:

       

       

      GRDSS - Payment On Time % = COUNTAX( table, table[column] ) / [Volume of Supplier Invoices Paid]

       

       

      DIVIDE function vs divide operator (/) 

       

      If it not work, please give me a sample data model.

       

      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.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi , Yes right result 0.79 but i am getting as 1 After Using GROSS - Payment On Time % = COUNTAX( 'Append-France,Greece,Monaco', 'Append-France,Greece,Monaco'[Status POT ] ) / [Volume of Supplier Invoices Paid] Thanks In Advance.