https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Groups-Very-Slow/m-p/2800983#M88118 <P>I am working on a report that uses<SPAN>&nbsp;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).&nbsp; There is also a perspective set up to allow them to pull in certain dimensions from the dataset.&nbsp; This is all set up in Tabular Editor opened from the dataset.&nbsp; The KPIs are DAX measures within the Power BI Report itself.&nbsp; The dataset is a star schema and has several million records.</SPAN></P><P>&nbsp;</P><P>Does anyone have any advice for how to optimize and speed up calculation groups within Power BI?&nbsp; Could it be related to my DAX measures being in the report instead of the DS?&nbsp; Any advice or things to try would be helpful.&nbsp; Thanks!</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 27 Sep 2022 20:23:20 GMT Anonymous 2022-09-27T20:23:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Groups-Very-Slow/m-p/2800983#M88118 <P>I am working on a report that uses<SPAN>&nbsp;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).&nbsp; There is also a perspective set up to allow them to pull in certain dimensions from the dataset.&nbsp; This is all set up in Tabular Editor opened from the dataset.&nbsp; The KPIs are DAX measures within the Power BI Report itself.&nbsp; The dataset is a star schema and has several million records.</SPAN></P><P>&nbsp;</P><P>Does anyone have any advice for how to optimize and speed up calculation groups within Power BI?&nbsp; Could it be related to my DAX measures being in the report instead of the DS?&nbsp; Any advice or things to try would be helpful.&nbsp; Thanks!</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 27 Sep 2022 20:23:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Groups-Very-Slow/m-p/2800983#M88118 Anonymous 2022-09-27T20:23:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Groups-Very-Slow/m-p/2801412#M88148 <P>Anonymous</LI-USER> , refer if these can help</P> <P><A href="https://www.agile-analytics.com.au/blog/a-technique-for-optimising-calculation-group-performance/" target="_blank">https://www.agile-analytics.com.au/blog/a-technique-for-optimising-calculation-group-performance/</A></P> <P><A href="https://www.youtube.com/watch?v=52remtERZ6o" target="_blank">https://www.youtube.com/watch?v=52remtERZ6o</A></P> <P><A href="https://community.powerbi.com/t5/Issues/Calculation-Group-slows-down-as-the-number-of-Calculation-Items/idi-p/1706064" target="_blank">https://community.powerbi.com/t5/Issues/Calculation-Group-slows-down-as-the-number-of-Calculation-Items/idi-p/1706064</A></P> <P>&nbsp;</P> Wed, 28 Sep 2022 01:56:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Groups-Very-Slow/m-p/2801412#M88148 amitchandak 2022-09-28T01:56:10Z