Simple IF statement returning incorrect results

[Pwilson460]

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. 

HighRisk_Under0 = IF(  AR[Cash-NetSales]  > 0 ,"Low Risk","High Risk")

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 

[Pwilson460]

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.

[Pwilson460]

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.  

[Ritaf1983 · Accepted solution]

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.

[Ritaf1983]

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