Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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 | |
11 | |
10 | |
10 | |
9 |
User | Count |
---|---|
18 | |
13 | |
12 | |
11 | |
8 |