Forum Discussion
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.
2 Replies
- Hei_aQingHelper I
- v-henryk-mstfCommunity Support
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