Forum Discussion

rhborders's avatar
rhborders
Helper I
8 years ago

No accepting "=" in Switch function or IF function

I used this function = SWITCH(TRUE(),SUMX(Fact_Invoice_Line_Date_ID,Fact_Invoice_Line_Date_ID[Invoice_Date_Julian])>SUMX(Fact_Invoice_Line_Stdev,Fact_Invoice_Line_Stdev[Invoice Min Stdev]),1) which worked fine, however whenever I replace the ">" with an "=" I am unable to run the function. 

 

If you have any idea why this may be please let me know.

 

Thanks!

Need Help

2 Replies

    • rhborders's avatar
      rhborders
      Helper I
      8 years ago

      Any time that I run this function my memory is maxed out and it can't display it. When I check my task manager it shows that all of my memory is being used from SASS. I have the data imported from SQL. Any idea why this may be?