Calculation Groups Very Slow

[Anonymous]

I am working on a report that uses calculation groups to let users select which time intelligence groups they would like to see (CY YTD, PY PTD, YTD Variance, CY TTM, PY TTM, TTM Variance).  There is also a perspective set up to allow them to pull in certain dimensions from the dataset.  This is all set up in Tabular Editor opened from the dataset.  The KPIs are DAX measures within the Power BI Report itself.  The dataset is a star schema and has several million records.

Does anyone have any advice for how to optimize and speed up calculation groups within Power BI?  Could it be related to my DAX measures being in the report instead of the DS?  Any advice or things to try would be helpful.  Thanks!

[amitchandak]

@Anonymous , refer if these can help

https://www.agile-analytics.com.au/blog/a-technique-for-optimising-calculation-group-performance/

https://www.youtube.com/watch?v=52remtERZ6o

https://community.powerbi.com/t5/Issues/Calculation-Group-slows-down-as-the-number-of-Calculation-Items/idi-p/1706064