topic Multiple Calculation Groups in one Tabular Model in Developer https://community.fabric.microsoft.com/t5/Developer/Multiple-Calculation-Groups-in-one-Tabular-Model/m-p/3039752#M40877 <P>Hi all,&nbsp;</P><P>&nbsp;</P><P>Is there a limit to the number of separate calculation groups I can have in one tabular model?&nbsp;</P><P>&nbsp;</P><P>Current Calculation Group:</P><TABLE border="1"><TBODY><TR><TD><STRONG><FONT color="#800000">Measure</FONT></STRONG></TD><TD><STRONG><FONT color="#800000">Order</FONT></STRONG></TD></TR><TR><TD>Actuals MTD</TD><TD>1</TD></TR><TR><TD>Budget MTD</TD><TD>2</TD></TR><TR><TD>Actuals QTD</TD><TD>3</TD></TR><TR><TD>Budget QTD</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>I now need to have a calculation group like this:</P><TABLE border="1"><TBODY><TR><TD><FONT color="#800000"><STRONG>Measures</STRONG></FONT></TD><TD><FONT color="#800000"><STRONG>Order</STRONG></FONT></TD></TR><TR><TD>Actuals MTD</TD><TD>1</TD></TR><TR><TD>Actuals QTD</TD><TD>2</TD></TR><TR><TD>Actuals YTD</TD><TD>3</TD></TR><TR><TD>Budget MTD</TD><TD>4</TD></TR><TR><TD>Budget QTD</TD><TD>5</TD></TR><TR><TD>Budget YTD</TD><TD>6</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Should I just add a sort column to the existing calculation group or should I make a second calculation group and have both in the Tabular model?</P><P>&nbsp;</P><P>Thanks!</P> Tue, 24 Jan 2023 09:31:05 GMT PurpleGate 2023-01-24T09:31:05Z Multiple Calculation Groups in one Tabular Model https://community.fabric.microsoft.com/t5/Developer/Multiple-Calculation-Groups-in-one-Tabular-Model/m-p/3039752#M40877 <P>Hi all,&nbsp;</P><P>&nbsp;</P><P>Is there a limit to the number of separate calculation groups I can have in one tabular model?&nbsp;</P><P>&nbsp;</P><P>Current Calculation Group:</P><TABLE border="1"><TBODY><TR><TD><STRONG><FONT color="#800000">Measure</FONT></STRONG></TD><TD><STRONG><FONT color="#800000">Order</FONT></STRONG></TD></TR><TR><TD>Actuals MTD</TD><TD>1</TD></TR><TR><TD>Budget MTD</TD><TD>2</TD></TR><TR><TD>Actuals QTD</TD><TD>3</TD></TR><TR><TD>Budget QTD</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>I now need to have a calculation group like this:</P><TABLE border="1"><TBODY><TR><TD><FONT color="#800000"><STRONG>Measures</STRONG></FONT></TD><TD><FONT color="#800000"><STRONG>Order</STRONG></FONT></TD></TR><TR><TD>Actuals MTD</TD><TD>1</TD></TR><TR><TD>Actuals QTD</TD><TD>2</TD></TR><TR><TD>Actuals YTD</TD><TD>3</TD></TR><TR><TD>Budget MTD</TD><TD>4</TD></TR><TR><TD>Budget QTD</TD><TD>5</TD></TR><TR><TD>Budget YTD</TD><TD>6</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Should I just add a sort column to the existing calculation group or should I make a second calculation group and have both in the Tabular model?</P><P>&nbsp;</P><P>Thanks!</P> Tue, 24 Jan 2023 09:31:05 GMT https://community.fabric.microsoft.com/t5/Developer/Multiple-Calculation-Groups-in-one-Tabular-Model/m-p/3039752#M40877 PurpleGate 2023-01-24T09:31:05Z Re: Multiple Calculation Groups in one Tabular Model https://community.fabric.microsoft.com/t5/Developer/Multiple-Calculation-Groups-in-one-Tabular-Model/m-p/3041966#M40894 <P>Found a solution:</P><P>Looks like you can have multiple calculation groups in one power bi model.</P><P>&nbsp;</P><P>Kudos to this video:&nbsp;<A href="https://www.youtube.com/watch?v=LLZYvz5bxkM" target="_blank">https://www.youtube.com/watch?v=LLZYvz5bxkM</A>&nbsp;</P> Wed, 25 Jan 2023 07:52:46 GMT https://community.fabric.microsoft.com/t5/Developer/Multiple-Calculation-Groups-in-one-Tabular-Model/m-p/3041966#M40894 PurpleGate 2023-01-25T07:52:46Z