Hi All,
I've been trying to work only with measures not calculated columns because I've seen a few people say that they are way better and can do everything, but I'm stuck on something I can't seem to do in a measure. I think in this case I actually need to use a calculated column, so hoping for a response from one of those people who have said they never use calculated columns because measures can do everything.
OnlyPositives = If([Value]>0,[Value],0)
Category Value OnlyPositives
A -5 0
B 1 3
C 2 4
Total -2 0
This is what I currently have, but actually I want the total value of [OnlyPositives] to add up to 7. I understand that measures dont evaluate at a row level and therefore it is doing what I told it to, since -2 is >0 it is displaying 0.
My conclusion is that I do have to use calculated columns to do this. Which is quite frustrating because there are a tonne of measures which feed into [Value]. If I want to convert this to a calculated column I'm basically going to have to remake everything I've done in measures to calculated columns - which makes me want to just use calculated columns again in the future.
I have tried to make a single calculated column which references [Value] but I've spend a while on it already and am having trouble making it match up, so before I go further I was hoping to get a weigh in to make sure my thinking is right.
Thanks superstars.
