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.

     

     

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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-lionel-msft ,

     

    I want calulate it on :

    • GROSS - Payment On Time %: Filter Status=”30”, Status POT =” Before Due”,Country="France" and Process Count of Status POT divided by Volume of supplier invoices paid .
    • I have to use all the filters..
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-lionel-msft ,

     

    Your Logic was correct and  its Working fine Now.

    Leasson Learned:Filters has to keep in Measure not on the Filters on the Page.

     

    Thanks For your Help.