Incorrect Measure Total

[MintuBaruah]

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.

[v-henryk-mstf]

Hi @MintuBaruah ,

Related to your external context.  Can you provide the relevant test data and the formula created and I will answer you as soon as possible
How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Henry

[Hei_aQing]

Hi @MintuBaruah ,

see if helps.

Solved: Incorrect Totals in Measure - Microsoft Power BI Community