Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@Anonymous Have you tried sumx function
Measure = SUMX('Table',IF('Table'[Value]>0,'Table'[Value],0))
@Anonymous Have you tried sumx function
Measure = SUMX('Table',IF('Table'[Value]>0,'Table'[Value],0))
Thank you so much!
It's very basic but something I hadn't learnt yet.
Power BI Community to the rescue!
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |