Forum Discussion

MintuBaruah's avatar
MintuBaruah
Helper III
4 years ago

Incorrect Measure Total

Hi @all

 

The value of my total, when taken in a Table, for 2 Measures is showing incorrect, ie. negative values. But there are no negative values in the table.

 

Measure 1 = Sum( Table1[Col1] ) - Sum( Table2[Col2] )

In Measure 1 the first Sum always has the higher value, and the second one has the lower value so the result row vise is always positive.

 

Same for the second Measure.

 

Screenshot 1:

   

Screenshot 1 shows the values from lower to higher in the column for the measure.

 

Please help resolve this issue.