Forum Discussion

Pwilson460's avatar
Pwilson460
New Member
2 years ago
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...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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's avatar
Ritaf1983
Super User
2 years ago

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's avatar
Pwilson460
New Member
2 years ago

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's avatar
    Ritaf1983
    Super User
    2 years ago

    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.