Forum Discussion
Sagejah9
3 years agoHelper III
Measure returns incorrect total
Hi
I am trying to solve this issue with my measure where I am multiplying the sum by -1 to make it positive for certain line items that are in the data with negative values. However the measure is still summing the values with the negative numbers but in the matrix you can see that the numbers are positive.
Any ideas as to why this is happening?
Please see this video for how to get your expected result with SUMX().
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat
1 Reply
- ppm1Solution Sage
Please see this video for how to get your expected result with SUMX().
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat