Hello, I need to sum the negative and positive numbers in a column.
For example, some orders used to be cancled after it is entered. I use sumx function but the it considers the negative values as the positive ones. Please help!
Go to Solution.
what is your desired output?
if you need only sum of positive or only negative values try calculations like
CALCULATE(SUM([Sales Value]), [Sales Value]>0)
CALCULATE(SUM([Sales Value]), [Sales Value]<0)
View solution in original post
Normal sum should have work.
Drag order number and measure in table visual.
Thanks & regards,Pravin Wattamwarwww.linkedin.com/in/pravin-p-wattamwarIf I resolve your problem Mark it as a solution and give kudos.
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.