Power BI load is very slow when connected to SSAS Tabular Model

[SwathiBattikadi]

Hi Team, 

I have been struggling with the below issue with MTD/QTD/YTD DAX formula limitations in SSAS. I have created 36 DAX Measures (MTD,QTD,YTD) in my SSAS Tabular model and when trying to pull them in desktop the performance is very slow but when i connect the report to Azure DB the performance is faster with the below formula(Formula 1). 

Used below formula for MTD/QTD/YTD calculations in Power BI:

Formula 1: MTDSales=TotalMTD(GrossSales,TableName(Date).[Date]) -- Performance is fast in Power BI with this formula

Whereas in SSAS I can write below formula,

Formula 2: MTDSales=TotalMTD(GrossSales,TableName(Date)) (unable to get .[Date] extension here).

From my observations MTD/QTD/YTD calculations are very slow when used Formula 2 even in Power BI but the queries work faster when used Formula 1. Can someone please assist me how can i achive this in SSAS? 

[dpilats]

I will share my case. My report was very slow. I also "Specified Mark as Date Table for use with Time Intelligence". Did not help.
The problem was due to custom filter "Smart filter by OKViz". I deleted it and performance was fantastic again.
I suggest to use filter panel.
Step 1: open power bi options - Global
Step 2: Preview features - Select "New filter experiance". Restart PowerBI.
Step 3. open power bi options - current file - select "enable the updated filter pane". Restart if required.
Ready!
Get rid of filter box on every page, use only this pane and enjoy.
All calculation dax logic should be on AS side, no Power BI dax'ing.

[v-chuncz-msft]

@SwathiBattikadi,

You may take a look at Specify Mark as Date Table for use with Time Intelligence.