Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PBI calculating wrong with negative values

I experience that Powerbi returns a positive value where it should be negative when starting with a negative number.
Example:
Value1 : -0,001010

Value2 : 0,000011
Value1 - Value2 = -0,001010 -0,000011 returns 0,001021...

It is almost correct exept that it should be a negative number returned not a positive.
In my dax example underneath, it is wrapped in Averagex to catch if the user as selected a range. In reality the user is only selecting two numbers. 

My dax example:

Controle_4148_Top-Bottom =
//find pivot point
var A1 = MEDIANX('Samlet','Samlet'[4148.DC 1 [V]]])

//calculate sum of points over and under pivot
Var SumOverAndUnderPivot =
AVERAGEX(Filter('Samlet', 'Samlet'[4148.DC 1 [V]]] >= A1 ),'Samlet'[4148.DC 1 [V]]]) -
AVERAGEX(Filter('Samlet', 'Samlet'[4148.DC 1 [V]]] < A1), 'Samlet'[4148.DC 1 [V]]])
 
// Calculate and return as I
return  SumOverAndUnderPivot




I am working with measurements where the instrument have an accuracy of 6 digits.

Reports

1 Reply

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

    Anonymous ,

     

    I have made a test but couldn't reproduce your issue. The result is negative on my side. Please make sure power bi desktop has been updated to the latest version.

     

     

    Regards,

    Jimmy Tao