Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. 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!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
18 | |
14 | |
11 | |
10 | |
9 |