Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Solved! Go to Solution.
Hi,
I recommend reading this article by sqlbi to understand what is going on here: Obtaining accurate totals in DAX - SQLBI
Basically the totals work in mysterious ways and even if your measure would work on a row level it will not work at total level. E.g.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
hi @Ttaylor9870
when you say negative Free Stock Value, negative under what context?
Hi @FreemanZ,
Negative e.g. I subtract the 2 values away from eachother. Both numbers in the columns are always going to be positive so the new number in the measure column could possible be negative and I want those negatives to display zero instead of displaying as the negative number.
I am trying to work out free stock so....
Quantity = Stock currently sitting
Outstanding = Stock sold
Hi,
I recommend reading this article by sqlbi to understand what is going on here: Obtaining accurate totals in DAX - SQLBI
Basically the totals work in mysterious ways and even if your measure would work on a row level it will not work at total level. E.g.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
10 | |
10 | |
9 | |
9 |
User | Count |
---|---|
20 | |
13 | |
13 | |
11 | |
8 |