The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |