Yesterday Sales no longer calculating

[Roseventura]

Help! 

I have an INVOICE file that contains the usual stuff:  Extended Sales Amount, Invoice Number, Invoice Date, etc. 

I created a measure call Yesterday which is simply Yesterday = today()-1. 

Then created another measure: 

Yesterday's Sales = CALCULATE(sum(Invoice_16[Total Extended Sales]),filter(Invoice_16,Invoice_16[Invoice Date]=Invoice_16[Yesterday]))

What I need it to do is add up all the Extended Sales Amounts where Invoice Date = Yesterday.   Both dates are formatted the same (M/dd/yyyy).  I wouldn't think that would matter, but they are the same nonetheless.

This was working up until a few days ago.  Now my visual just returns (Blank).

What went wrong?

[CahabaData]

well...sanity check; add a new table visual with several (or all) of the columns of the Invoice table plus your 2 measures.....  is there data all there?  will only take a minute.....

[Roseventura]

Yes, I tried that multiple times. I even created a new report, importing the invoice table, recreated the measures and I'm still getting BLANK. This was working up until a few days ago when I loaded the latest version. Now it seems that nothing is working. I can't even refresh my tables anymore. I'm very worried because I have to present this to upper management the week after next and now I can't get anything to work. Very frustrated. Rose

[CahabaData]

definitely a bummer... I hope others will join in with some suggestions.  What I myself would do - is still go back to basics on the sanity check by starting a brand new file (not just a new report) - do a brand new Get Data import - - and see that data in tables - and then make the measure.  It doesn't take long and the goal is to establish whether the PBI install works or doesn't.

right now it seems to point to the install but on the other hand a measure could return a blank if that is the correct result of the logic meaning that the data itself has changed.

what to do next kind of depends on what you find

[Roseventura · Accepted solution]

I was able to downgrade to the August version and my problems have been resolved.  All my objects are displaying the measure results correctly, including Yesterday's Sales, YTD Sales, QTD Sales and MTD.

Rose