second filter in calculate dont work

[powerbityro]

Hi All,

The second filter in my CALCULATE formula doesn't work (it don't respect the row filter)... can someone tell my why or what would be the right formula?

sale_quarter-1 = CALCULATE(SUM(view[sale]) ; ALL(view[year_quarter]); view[DatePreviousQuarter])

I work with Direct Query so that some functions like time intelligence, DATEADD don't work. Therefore the DatePreviousQuarter I wrote via the SWITCH function.

[v-cherch-msft]

Hi @powerbityro 

DATEADD could not work in Direct Query mode.You may refer to this article.If you need further help,please follow the How to Get Your Question Answered Quickly to post your simple assumed data and expected output.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,