SUMX function in Measure is returning wrong Value

[kauhsik_11]

So basically i want the Monthly average of a particular KPI but the monthly average is calculated based on whter the daily percentage is above or below a set target.
so for example if a KPI is above 90%(which is the target), it is considered as 100% but if it is 89% it is considered as 89%
so when i use SUMX to find the Monthly avg in the KPI card its returning wrong value.

The las column is a calculated column i am using to calculate the monthly Average as mentioned above

So her the monthly avg in Percentage would be
[ {sum of "total FC"- sum of number of loss (CC)} / sum of Total FC ] which will be 279-27/279= 90.32%
but for some reason its showing 89.89%

This is the Measure i used to calculate the avg.

Monthly Average =

 Divide(

    SUMX(OFCP, OFCP[Total FC (nos.)]) - SUMX(OFCP, OFCP[Number of loss (CC)]),
    SUMX(OFCP, OFCP[Total FC (nos.)])
)
Even if i use only the SUM() function the value is wrong
FYI I only know DAX but not M Code or Visual Basics
Thanks in advance

[Anonymous]

Hi @kauhsik_11 

After my testing, I've tried both methods and I don't have the problem you're experiencing.

Here are my suggestions:

• Create two different measurements and check if the answers obtained from the following two formulas are correct.

SUMX(OFCP, OFCP[Total FC (nos.)])

SUMX(OFCP, OFCP[Number of loss (CC)])

• Is the Target field the source data or is it calculated? In my testing, the Target field is the source data.

Best Regards,
Community Support Team _Yuliax

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

[Ashish_Mathur]

Hi,

Share data in a format the can be pasted in an MS Excel file and show the expected result very clearly.

[Bmejia]

Hi,  I recreated your problem and I didn't get the wrong value you mention.  Make sure that you don't have any filter or any item in the visual highlighted, that could be could posibly be excluding values.