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

     

     

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.

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous 

    if you get 1, maybe you just do not define Decimal places parameter as it need?

    do not hesitate to give a kudo to useful posts and mark solutions as solution

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

      I think this is the reason.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi az38 ,

       

      i have given 2 as decimal place in Modelling it giveds me 1.00

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        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.

         

         

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

    Hi Anonymous ,

    Can you give me your .PBIX file?

    Maybe we need to modify the DAX of  [Volume of Supplier Invoices Paid] .

     

    Regards,
    Lionel Chen

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lionel-msft 

       

      I have used measure as below:

       

      Volume of Supplier Invoices Paid = COUNTX(FILTER('Append-France,Greece,Monaco','Append-France,Greece,Monaco'[Status]=30),'Append-France,Greece,Monaco'[Status])

       

      i am unable to share PBIX file as per the security norms of organisation.

       

      Best Wishes,

      Younis Syed