Forum Discussion
How to handle negative Values in PowerBI
Hi all
I have 3 main measures on a report which showcase how many IPs in total, how many are alive and not alive. These measures are straighforward like sum and subtraction.
But problem is depending on what I select on other bar or pie chart in other measures which say focusing on if an IP is on a certain network so when select that specifically in the bar chart not alive becomes negative as that simple subtraction was based on total IP but now thats changed and it gets reflected there hence negative.
Any idea how to tackle this so that it shows 0 rather than negative value?
Hope I made the problem statement clear.
Thanks.
2 Replies
- parry2k
Super User
tachow13 not exactly clear what you are trying to achieve. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490