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 ...
Need Help
mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Hi tachow13 

 

Not pretty sure if I have understood you, but... Why don't you try to use a variable (var result=<Your measure>) and then put an if condition: IF (result<0,0, result)