Forum Discussion
Solved
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 balanc...
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.
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
Super User
Super UserHi 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.