Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |