topic Re: Multiple Rows in Matrix with Calculated Measure Problem in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Rows-in-Matrix-with-Calculated-Measure-Problem/m-p/1030704#M13514 <P>any idea&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp;please</P> Thu, 16 Apr 2020 17:14:16 GMT Anonymous 2020-04-16T17:14:16Z Multiple Rows in Matrix with Calculated Measure Problem https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Rows-in-Matrix-with-Calculated-Measure-Problem/m-p/1030680#M13511 <P>Help please</P><P>&nbsp;</P><P>I have a Matrix visual with two row fields. The calculated measure below only works when I have one field and not two. Please assist</P><P>&nbsp;</P><DIV><DIV><SPAN>CALCULATE(DISTINCTCOUNT(Data_Load[Account_Number]), DATESMTD(Data_Load[Account_Open_Date]),Data_Load[Account_Open_Date])</SPAN></DIV></DIV><P>&nbsp;</P><TABLE><TBODY><TR><TD>Product_Code_Desc</TD><TD>Sub_Product_Desc</TD><TD>Sales MTD</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_1</TD><TD>586</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_2</TD><TD>1</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_3</TD><TD>44</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_4</TD><TD>40</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_5</TD><TD>5</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_6</TD><TD>1</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_7</TD><TD>1</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_8</TD><TD>25</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_9</TD><TD>2</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_10</TD><TD>2</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_11</TD><TD>3</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_12</TD><TD>1</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_13</TD><TD>10</TD></TR><TR><TD>Prod_1</TD><TD>sub_prod_14</TD><TD>361</TD></TR><TR><TD>Total</TD><TD>&nbsp;</TD><TD>697</TD></TR><TR><TD>Prod_2</TD><TD>sub_prod_15</TD><TD>1</TD></TR><TR><TD>Prod_2</TD><TD>sub_prod_16</TD><TD>13</TD></TR><TR><TD>Prod_2</TD><TD>sub_prod_17</TD><TD>559</TD></TR><TR><TD>Prod_2</TD><TD>sub_prod_18</TD><TD>18</TD></TR><TR><TD>Prod_2</TD><TD>sub_prod_19</TD><TD>653</TD></TR><TR><TD>Prod_2</TD><TD>sub_prod_20</TD><TD>3</TD></TR><TR><TD>Prod_2</TD><TD>sub_prod_21</TD><TD>34</TD></TR><TR><TD>Prod_2</TD><TD>sub_prod_22</TD><TD>35</TD></TR><TR><TD>Prod_2</TD><TD>sub_prod_23</TD><TD>8869</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1268</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="119281" data-lia-user-login="dax" class="lia-mention lia-mention-user">dax</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="62350" data-lia-user-login="NewB" class="lia-mention lia-mention-user">NewB</a>&nbsp;</P> Thu, 16 Apr 2020 16:56:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Rows-in-Matrix-with-Calculated-Measure-Problem/m-p/1030680#M13511 Anonymous 2020-04-16T16:56:38Z Re: Multiple Rows in Matrix with Calculated Measure Problem https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Rows-in-Matrix-with-Calculated-Measure-Problem/m-p/1030704#M13514 <P>any idea&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp;please</P> Thu, 16 Apr 2020 17:14:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Rows-in-Matrix-with-Calculated-Measure-Problem/m-p/1030704#M13514 Anonymous 2020-04-16T17:14:16Z Re: Multiple Rows in Matrix with Calculated Measure Problem https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Rows-in-Matrix-with-Calculated-Measure-Problem/m-p/1030793#M13517 <P>Seems like there is some missing information here. Like a date table, some relationships to the date table, etc.</P> <P>&nbsp;</P> <P>Is that source data you present and what is the measure name for the formula you provided?</P> <P>&nbsp;</P> <P>Please see this post regarding How to Get Your Question Answered Quickly: <A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490</A></P> Thu, 16 Apr 2020 18:01:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Rows-in-Matrix-with-Calculated-Measure-Problem/m-p/1030793#M13517 Greg_Deckler 2020-04-16T18:01:08Z