topic Percentage calculation is not spliting by Month in Matrix table in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Percentage-calculation-is-not-spliting-by-Month-in-Matrix-table/m-p/1943193#M42285 <P>Hi,</P><P>I am constructing a PL report based on the static template of Finance operations(Ledger transactions).&nbsp; Here i listed only few records to explain my problem.</P><P>&nbsp;</P><P>Based on the Ids listed, i am trying to calculating total and percentage in DAX formula.</P><P>&nbsp;</P><P>The amount and percentage&nbsp; should be&nbsp; calculated by the month split in matrix table Jan,feb.....dec.</P><P>&nbsp;</P><P>Could you please advise.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG><FONT color="#003300">Id</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Description</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">MainAccount</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Date</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Amount</FONT></STRONG></TD></TR><TR><TD>40</TD><TD>PARENTS REVENUE</TD><TD>&nbsp;R706000</TD><TD>1/1/2021</TD><TD>2000</TD></TR><TR><TD>41</TD><TD>RETURN CHECK/DD FEES INVOICED</TD><TD>&nbsp;R706150</TD><TD>22/2/2021</TD><TD>2800</TD></TR><TR><TD>42</TD><TD>CREDIT NOTES - PARENTS</TD><TD>&nbsp;R706900</TD><TD>10/3/2021</TD><TD>2800</TD></TR><TR><TD>44</TD><TD>DISCOUNTS</TD><TD>&nbsp;R706910</TD><TD>4/4/2021</TD><TD>2091</TD></TR><TR><TD>46</TD><TD>DISCOUNTS ON SPECIAL OFFERS</TD><TD>&nbsp;R706920</TD><TD>8/5/2021</TD><TD>2800</TD></TR><TR><TD>48</TD><TD>PARENTS REVENUE SUBSIDIES</TD><TD>&nbsp;R741000</TD><TD>13/6/2021</TD><TD>200</TD></TR><TR><TD>50</TD><TD>CATERING FEES</TD><TD>&nbsp;R706050</TD><TD>2/7/2021</TD><TD>2005</TD></TR><TR><TD>52</TD><TD>MEDICAL FEES</TD><TD>&nbsp;R706350</TD><TD>19/8/2021</TD><TD>235</TD></TR><TR><TD>54</TD><TD>TRANSPORTATION REVENUE</TD><TD>&nbsp;R706100</TD><TD>8/5/2021</TD><TD>2010</TD></TR><TR><TD>58</TD><TD>OTHER CHILDCARE REVENUE</TD><TD>&nbsp;R706200</TD><TD>10/3/2021</TD><TD>220</TD></TR><TR><TD>59</TD><TD>Credit Note - Parents Catering</TD><TD>&nbsp;R706903</TD><TD>11/10/2021</TD><TD>90</TD></TR><TR><TD>60</TD><TD>ENRICHMENT INCOME</TD><TD>&nbsp;R708050</TD><TD>10/12/2021</TD><TD>5</TD></TR><TR><TD>61</TD><TD>UNIFORMS/ATTIRE INCOME</TD><TD>&nbsp;R708600</TD><TD>10/3/2021</TD><TD>260</TD></TR><TR><TD>62</TD><TD>REGISTRATION FEES</TD><TD>&nbsp;R708002</TD><TD>11/10/2021</TD><TD>0</TD></TR><TR><TD><STRONG><FONT color="#008000">REV1</FONT></STRONG></TD><TD><STRONG><FONT color="#008000">Parents Revenue Total</FONT></STRONG></TD><TD><STRONG><FONT color="#008000">40+41+42+44+46+48+50+52+54+58+59+60+61+62</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#FF0000">68</FONT></STRONG></TD><TD><STRONG><FONT color="#FF0000">% Total Parents Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#FF0000">REV1/REV7</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>72</TD><TD>OPERATING SUBSIDIES</TD><TD>&nbsp;R740000</TD><TD>3/1/2021</TD><TD>2000</TD></TR><TR><TD>73</TD><TD>Operating Subsidies - BaWü</TD><TD>&nbsp;R740100</TD><TD>4/4/2021</TD><TD>2800</TD></TR><TR><TD>74</TD><TD>MFF SUBSIDIES</TD><TD>&nbsp;R740200</TD><TD>8/5/2021</TD><TD>2020</TD></TR><TR><TD>76</TD><TD>BUMI SUBSIDIES</TD><TD>&nbsp;R740250</TD><TD>13/6/2021</TD><TD>225</TD></TR><TR><TD>78</TD><TD>FOOD PROGRAM REVENUE</TD><TD>&nbsp;R740300</TD><TD>2/7/2021</TD><TD>2030</TD></TR><TR><TD>80</TD><TD>TRANSPORTATION REVENUES</TD><TD>&nbsp;R740350</TD><TD>19/8/2021</TD><TD>235</TD></TR><TR><TD>81</TD><TD>PARENTS REVENUE SUBSIDIES - Catering</TD><TD>&nbsp;R741050</TD><TD>8/5/2021</TD><TD>2005</TD></TR><TR><TD>82</TD><TD>PARENTS REVENUE SUBSIDIES - MFF</TD><TD>&nbsp;R741200</TD><TD>10/3/2021</TD><TD>220</TD></TR><TR><TD>83</TD><TD>OTHER OPERATING SUBSIDIES</TD><TD>&nbsp;R742000</TD><TD>11/10/2021</TD><TD>0</TD></TR><TR><TD>84</TD><TD>OPERATING SUBSIDIES ADJUSTMENTS</TD><TD>&nbsp;R742001</TD><TD>10/12/2021</TD><TD>0</TD></TR><TR><TD>86</TD><TD>CONTROL CAF</TD><TD>&nbsp;R742004</TD><TD>10/3/2021</TD><TD>200</TD></TR><TR><TD>87</TD><TD>Other subsidies</TD><TD>&nbsp;R742005</TD><TD>11/10/2021</TD><TD>0</TD></TR><TR><TD><STRONG><FONT color="#003300">REV2</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Subsidies Total</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">72+73+74+76+78+80+81+82+83+84+86+87</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#FF0000">89</FONT></STRONG></TD><TD><STRONG><FONT color="#FF0000">% Total Subsidies Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#FF0000">REV2/REV7</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#003300">REV3</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Total Childcare Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">REV1+REV2</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#003300">91</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">% Total Childcare Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">REV3/REV7</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>93</TD><TD>SPONSOR FEES - CORPORATES</TD><TD>&nbsp;R706001</TD><TD>8/5/2021</TD><TD>2800</TD></TR><TR><TD>94</TD><TD>CREDIT NOTES – CORPORATES</TD><TD>&nbsp;R706901</TD><TD>13/6/2021</TD><TD>2800</TD></TR><TR><TD>95</TD><TD>Key Accounts</TD><TD>&nbsp;R708005</TD><TD>2/7/2021</TD><TD>2000</TD></TR><TR><TD>96</TD><TD>State &amp; Hospital</TD><TD>&nbsp;R708006</TD><TD>19/8/2021</TD><TD>200</TD></TR><TR><TD>97</TD><TD>Small business &amp; Regional Group</TD><TD>&nbsp;R708007</TD><TD>8/5/2021</TD><TD>2000</TD></TR><TR><TD>99</TD><TD>VACANT CRADLES INVOICED</TD><TD>&nbsp;R708100</TD><TD>10/3/2021</TD><TD>210</TD></TR><TR><TD><STRONG><FONT color="#003300">REV4</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Total Corporate Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">93+94+95+96+97+99+REV4</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><FONT color="#FF0000"><STRONG>100</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>% Total Corporate Revenue</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>REV4/REV7</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>102</TD><TD>SPONSOR FEES - MUNICIPALITIES</TD><TD>&nbsp;R706002</TD><TD>2/7/2021</TD><TD>2800</TD></TR><TR><TD>104</TD><TD>CREDIT NOTES - MUNICIPALITIES</TD><TD>&nbsp;R706902</TD><TD>19/8/2021</TD><TD>3100</TD></TR><TR><TD>106</TD><TD>MUNICIPALITIES BONUS AND PENALTIES</TD><TD>&nbsp;R706102</TD><TD>8/5/2021</TD><TD>2800</TD></TR><TR><TD><FONT color="#003300"><STRONG>REV5</STRONG></FONT></TD><TD><FONT color="#003300"><STRONG>Total Municipalities Revenue</STRONG></FONT></TD><TD><FONT color="#003300"><STRONG>102+104+106</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><FONT color="#FF0000"><STRONG>110</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>% Total Municipalities Revenue</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>REV5/REV7</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>116</TD><TD>IC PERSONNEL REINVOICING</TD><TD>&nbsp;R708424</TD><TD>2/7/2021</TD><TD>2042</TD></TR><TR><TD>120</TD><TD>OTHER REVENUE</TD><TD>&nbsp;R708001</TD><TD>19/8/2021</TD><TD>200</TD></TR><TR><TD><FONT color="#003300"><STRONG>REV6</STRONG></FONT></TD><TD><FONT color="#003300"><STRONG>Total Other Revenue</STRONG></FONT></TD><TD><FONT color="#003300"><STRONG>116+120</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><FONT color="#FF0000"><STRONG>140</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>% Total Other Revenue</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>REV6/REV7</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#003300">REV7</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Total Nurseries Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">REV3+REV4+REV5+REV6</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks</P><P>Vinoth</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 07 Jul 2021 13:43:10 GMT Vinothsusai 2021-07-07T13:43:10Z Percentage calculation is not spliting by Month in Matrix table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Percentage-calculation-is-not-spliting-by-Month-in-Matrix-table/m-p/1943193#M42285 <P>Hi,</P><P>I am constructing a PL report based on the static template of Finance operations(Ledger transactions).&nbsp; Here i listed only few records to explain my problem.</P><P>&nbsp;</P><P>Based on the Ids listed, i am trying to calculating total and percentage in DAX formula.</P><P>&nbsp;</P><P>The amount and percentage&nbsp; should be&nbsp; calculated by the month split in matrix table Jan,feb.....dec.</P><P>&nbsp;</P><P>Could you please advise.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG><FONT color="#003300">Id</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Description</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">MainAccount</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Date</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Amount</FONT></STRONG></TD></TR><TR><TD>40</TD><TD>PARENTS REVENUE</TD><TD>&nbsp;R706000</TD><TD>1/1/2021</TD><TD>2000</TD></TR><TR><TD>41</TD><TD>RETURN CHECK/DD FEES INVOICED</TD><TD>&nbsp;R706150</TD><TD>22/2/2021</TD><TD>2800</TD></TR><TR><TD>42</TD><TD>CREDIT NOTES - PARENTS</TD><TD>&nbsp;R706900</TD><TD>10/3/2021</TD><TD>2800</TD></TR><TR><TD>44</TD><TD>DISCOUNTS</TD><TD>&nbsp;R706910</TD><TD>4/4/2021</TD><TD>2091</TD></TR><TR><TD>46</TD><TD>DISCOUNTS ON SPECIAL OFFERS</TD><TD>&nbsp;R706920</TD><TD>8/5/2021</TD><TD>2800</TD></TR><TR><TD>48</TD><TD>PARENTS REVENUE SUBSIDIES</TD><TD>&nbsp;R741000</TD><TD>13/6/2021</TD><TD>200</TD></TR><TR><TD>50</TD><TD>CATERING FEES</TD><TD>&nbsp;R706050</TD><TD>2/7/2021</TD><TD>2005</TD></TR><TR><TD>52</TD><TD>MEDICAL FEES</TD><TD>&nbsp;R706350</TD><TD>19/8/2021</TD><TD>235</TD></TR><TR><TD>54</TD><TD>TRANSPORTATION REVENUE</TD><TD>&nbsp;R706100</TD><TD>8/5/2021</TD><TD>2010</TD></TR><TR><TD>58</TD><TD>OTHER CHILDCARE REVENUE</TD><TD>&nbsp;R706200</TD><TD>10/3/2021</TD><TD>220</TD></TR><TR><TD>59</TD><TD>Credit Note - Parents Catering</TD><TD>&nbsp;R706903</TD><TD>11/10/2021</TD><TD>90</TD></TR><TR><TD>60</TD><TD>ENRICHMENT INCOME</TD><TD>&nbsp;R708050</TD><TD>10/12/2021</TD><TD>5</TD></TR><TR><TD>61</TD><TD>UNIFORMS/ATTIRE INCOME</TD><TD>&nbsp;R708600</TD><TD>10/3/2021</TD><TD>260</TD></TR><TR><TD>62</TD><TD>REGISTRATION FEES</TD><TD>&nbsp;R708002</TD><TD>11/10/2021</TD><TD>0</TD></TR><TR><TD><STRONG><FONT color="#008000">REV1</FONT></STRONG></TD><TD><STRONG><FONT color="#008000">Parents Revenue Total</FONT></STRONG></TD><TD><STRONG><FONT color="#008000">40+41+42+44+46+48+50+52+54+58+59+60+61+62</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#FF0000">68</FONT></STRONG></TD><TD><STRONG><FONT color="#FF0000">% Total Parents Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#FF0000">REV1/REV7</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>72</TD><TD>OPERATING SUBSIDIES</TD><TD>&nbsp;R740000</TD><TD>3/1/2021</TD><TD>2000</TD></TR><TR><TD>73</TD><TD>Operating Subsidies - BaWü</TD><TD>&nbsp;R740100</TD><TD>4/4/2021</TD><TD>2800</TD></TR><TR><TD>74</TD><TD>MFF SUBSIDIES</TD><TD>&nbsp;R740200</TD><TD>8/5/2021</TD><TD>2020</TD></TR><TR><TD>76</TD><TD>BUMI SUBSIDIES</TD><TD>&nbsp;R740250</TD><TD>13/6/2021</TD><TD>225</TD></TR><TR><TD>78</TD><TD>FOOD PROGRAM REVENUE</TD><TD>&nbsp;R740300</TD><TD>2/7/2021</TD><TD>2030</TD></TR><TR><TD>80</TD><TD>TRANSPORTATION REVENUES</TD><TD>&nbsp;R740350</TD><TD>19/8/2021</TD><TD>235</TD></TR><TR><TD>81</TD><TD>PARENTS REVENUE SUBSIDIES - Catering</TD><TD>&nbsp;R741050</TD><TD>8/5/2021</TD><TD>2005</TD></TR><TR><TD>82</TD><TD>PARENTS REVENUE SUBSIDIES - MFF</TD><TD>&nbsp;R741200</TD><TD>10/3/2021</TD><TD>220</TD></TR><TR><TD>83</TD><TD>OTHER OPERATING SUBSIDIES</TD><TD>&nbsp;R742000</TD><TD>11/10/2021</TD><TD>0</TD></TR><TR><TD>84</TD><TD>OPERATING SUBSIDIES ADJUSTMENTS</TD><TD>&nbsp;R742001</TD><TD>10/12/2021</TD><TD>0</TD></TR><TR><TD>86</TD><TD>CONTROL CAF</TD><TD>&nbsp;R742004</TD><TD>10/3/2021</TD><TD>200</TD></TR><TR><TD>87</TD><TD>Other subsidies</TD><TD>&nbsp;R742005</TD><TD>11/10/2021</TD><TD>0</TD></TR><TR><TD><STRONG><FONT color="#003300">REV2</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Subsidies Total</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">72+73+74+76+78+80+81+82+83+84+86+87</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#FF0000">89</FONT></STRONG></TD><TD><STRONG><FONT color="#FF0000">% Total Subsidies Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#FF0000">REV2/REV7</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#003300">REV3</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Total Childcare Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">REV1+REV2</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#003300">91</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">% Total Childcare Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">REV3/REV7</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>93</TD><TD>SPONSOR FEES - CORPORATES</TD><TD>&nbsp;R706001</TD><TD>8/5/2021</TD><TD>2800</TD></TR><TR><TD>94</TD><TD>CREDIT NOTES – CORPORATES</TD><TD>&nbsp;R706901</TD><TD>13/6/2021</TD><TD>2800</TD></TR><TR><TD>95</TD><TD>Key Accounts</TD><TD>&nbsp;R708005</TD><TD>2/7/2021</TD><TD>2000</TD></TR><TR><TD>96</TD><TD>State &amp; Hospital</TD><TD>&nbsp;R708006</TD><TD>19/8/2021</TD><TD>200</TD></TR><TR><TD>97</TD><TD>Small business &amp; Regional Group</TD><TD>&nbsp;R708007</TD><TD>8/5/2021</TD><TD>2000</TD></TR><TR><TD>99</TD><TD>VACANT CRADLES INVOICED</TD><TD>&nbsp;R708100</TD><TD>10/3/2021</TD><TD>210</TD></TR><TR><TD><STRONG><FONT color="#003300">REV4</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Total Corporate Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">93+94+95+96+97+99+REV4</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><FONT color="#FF0000"><STRONG>100</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>% Total Corporate Revenue</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>REV4/REV7</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>102</TD><TD>SPONSOR FEES - MUNICIPALITIES</TD><TD>&nbsp;R706002</TD><TD>2/7/2021</TD><TD>2800</TD></TR><TR><TD>104</TD><TD>CREDIT NOTES - MUNICIPALITIES</TD><TD>&nbsp;R706902</TD><TD>19/8/2021</TD><TD>3100</TD></TR><TR><TD>106</TD><TD>MUNICIPALITIES BONUS AND PENALTIES</TD><TD>&nbsp;R706102</TD><TD>8/5/2021</TD><TD>2800</TD></TR><TR><TD><FONT color="#003300"><STRONG>REV5</STRONG></FONT></TD><TD><FONT color="#003300"><STRONG>Total Municipalities Revenue</STRONG></FONT></TD><TD><FONT color="#003300"><STRONG>102+104+106</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><FONT color="#FF0000"><STRONG>110</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>% Total Municipalities Revenue</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>REV5/REV7</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>116</TD><TD>IC PERSONNEL REINVOICING</TD><TD>&nbsp;R708424</TD><TD>2/7/2021</TD><TD>2042</TD></TR><TR><TD>120</TD><TD>OTHER REVENUE</TD><TD>&nbsp;R708001</TD><TD>19/8/2021</TD><TD>200</TD></TR><TR><TD><FONT color="#003300"><STRONG>REV6</STRONG></FONT></TD><TD><FONT color="#003300"><STRONG>Total Other Revenue</STRONG></FONT></TD><TD><FONT color="#003300"><STRONG>116+120</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><FONT color="#FF0000"><STRONG>140</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>% Total Other Revenue</STRONG></FONT></TD><TD><FONT color="#FF0000"><STRONG>REV6/REV7</STRONG></FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG><FONT color="#003300">REV7</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">Total Nurseries Revenue</FONT></STRONG></TD><TD><STRONG><FONT color="#003300">REV3+REV4+REV5+REV6</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks</P><P>Vinoth</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 07 Jul 2021 13:43:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Percentage-calculation-is-not-spliting-by-Month-in-Matrix-table/m-p/1943193#M42285 Vinothsusai 2021-07-07T13:43:10Z Re: Percentage calculation is not spliting by Month in Matrix table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Percentage-calculation-is-not-spliting-by-Month-in-Matrix-table/m-p/1954640#M42641 <P>Hello,</P><P>Any advise please on the percentage calculation in DAX.</P><P>&nbsp;</P><P>Thanks</P><P>Vinoth</P> Tue, 13 Jul 2021 12:06:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Percentage-calculation-is-not-spliting-by-Month-in-Matrix-table/m-p/1954640#M42641 Vinothsusai 2021-07-13T12:06:10Z Re: Percentage calculation is not spliting by Month in Matrix table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Percentage-calculation-is-not-spliting-by-Month-in-Matrix-table/m-p/1978994#M43605 <P>Hello,</P><P>I have achieved this specific formula on total and percentage row by using Financial reporting matrix tool below.</P><P><A href="https://www.profitbase.com/powerbi/" target="_blank">https://www.profitbase.com/powerbi/</A></P><P>&nbsp;</P><P>I am facing the problem rendering data is little slow and also i cannot do "show data as point table" on each row.</P><P>&nbsp;</P><P>Expert,</P><P>Please advise on this, it can achieve through native power bi matrix table using DAX expressions?</P><P>&nbsp;</P><P>Thanks</P><P>Vinoth</P> Mon, 26 Jul 2021 09:35:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Percentage-calculation-is-not-spliting-by-Month-in-Matrix-table/m-p/1978994#M43605 Vinothsusai 2021-07-26T09:35:31Z