Forum Discussion
Simple IF statement returning incorrect results
Hello all,
I am pretty new to DAX but have spent a lot of time using excel.
I created this simple measure to allow users to filter a report for line items that are showing a negative balance by using a slicer.
The AR[Cash-NetSales] measure is just what it sounds like, current cash minus current net sales, and that measure works perfectly.
However when I select the "High Risk" check box on my newly created slicer it shows some lines in the visual with a positive value, I am expecting it to only show negative values.
What am I missing here?
Thanks so much
Hi Pwilson460
I replicated your scenario and it works as it should :The pbix is attached, you can follow my steps
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
5 Replies
- Ritaf1983
Super User
Hi Pwilson460
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 Here is a table of sample data I have been using. I would expect all results labeled with "High Risk" to be negative from the following expression.
HighRisk_Under0 = IF( AccountReceivable[CashLast4-NetLast4] > 0 ,"Low Risk","High Risk")Company Name Sales Last 4 Weeks Cash Last 4 Weeks Variance HighRisk_Under0 AAA $177,884 $819 ($177,065) High Risk BBB $15,810 $12,468 ($3,341) High Risk CCC $90,722 $134,205 $43,483 High Risk DD $7,020 $16,155 $9,135 High Risk FFF $16,155 $24,660 $8,505 High Risk GGG $20,996 $16,262 ($4,734) High Risk - Ritaf1983
Hi Pwilson460
I don't see the " NetLast4"...in this table...
Is the HighRisk_Under0 measure or calculated column...?It's still unclear what your data structure is and what you're trying to achieve.
NetLast4 is the Sales last 4 weeks column, CashLast4 is the cash last 4 weeks column.
You are correct I misspoke, the HighRisk_Under0 is a calculated column.
