Forum Discussion

tachow13's avatar
tachow13
New Member
3 years ago

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