DAX filters no longer working

[lcasey]

Power BI DAX may be broken after this latest update.  All of the sudden, filters are not working when using calculate.

I have a simple formula

Revenue Forecast = CALCULATE([Average Revenue] * SUMX('Cases','Cases'[Case Gap]),FILTER('Cases','Cases'[Case_CloseDate] = BLANK()))

Looking at the picture below the total should be $10,762 as I have filtered all cases to just Open cases but yet Revenue forecast formula shows a total value for cases that are open. The product I beleive is broken.

[v-yuta-msft]

@lcasey ,

I've made a test on this, however I couldn't reproduce your issue, filter() works well on my side. Please update power bi desktop to the lastest version. In addtion, my power bi version is like below.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vvelarde]

@lcasey 

Hi, why you don't use a SUM instead of SUMX in your formula.

Calculate(SUM('Cases'[CaseGAP]),FILTER(--------))

Maybe this give you more clarify about the issue.

Regards

[lcasey]

Using SUM produces the same exact result.  I beleive Power BI is completel;y broken now with this latest update.  It makes no sense why filters are not working in a calculate.

[v-yuta-msft · Accepted solution]

@lcasey ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[lcasey]

I did get it working, I just dont remember what it was I did. But the filters are working good now. 

Thanks!