topic Re: Pivot Table Target Measure in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3958191#M153604 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="312820" data-lia-user-login="DimaMD" class="lia-mention lia-mention-user">DimaMD</a>&nbsp;,</P><P>&nbsp;</P><P>I have had try that, but I got this one:</P><P><BR />Criada em (Month) | SemanaMes | Qty Atividade | measure 2</P><TABLE><TBODY><TR><TD>abr</TD><TD>1</TD><TD>446</TD><TD>5</TD></TR><TR><TD>abr</TD><TD>2</TD><TD>11</TD><TD>5</TD></TR><TR><TD>abr</TD><TD>3</TD><TD>1</TD><TD>5</TD></TR><TR><TD>abr</TD><TD>4</TD><TD>3</TD><TD>5</TD></TR><TR><TD>abr</TD><TD>5</TD><TD>1</TD><TD>5</TD></TR><TR><TD>mai</TD><TD>1</TD><TD>524</TD><TD>5</TD></TR><TR><TD>mai</TD><TD>2</TD><TD>701</TD><TD>5</TD></TR><TR><TD>mai</TD><TD>3</TD><TD>1</TD><TD>5</TD></TR><TR><TD>mai</TD><TD>4</TD><TD>2</TD><TD>5</TD></TR></TBODY></TABLE><P>Grand Total&nbsp;16905<BR /><BR /></P><P>Maybe the problem is here on calculated column:</P><P><!-- StartFragment --><SPAN class="">=</SPAN><SPAN class="">COUNTROWS</SPAN><SPAN class="">( </SPAN><SPAN class="">SUMMARIZE</SPAN><SPAN class="">(export_sensedata_atividades_2024_05_13;export_sensedata_atividades_2024_05_13[SemanaMes]))</SPAN><!-- EndFragment --></P><P><img /></P><P>&nbsp;</P><P>Before I forget:&nbsp;Slava Ukraini!!!</P> Wed, 29 May 2024 13:39:38 GMT Anonymous 2024-05-29T13:39:38Z Pivot Table Target Measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3956108#M153555 <P><SPAN>Hi guys... I need your help with a measure in Pivot Table with Excel.</SPAN></P><P>&nbsp;</P><P><SPAN>My goal is to have a measure (DisplayTotalWeeks) based on qty of "SemanaMes". In the case, it must return 9 like the example below.</SPAN></P><P><SPAN>Something like that:<BR /></SPAN></P><P>&nbsp;</P><P>Criada em (Month) SemanaMes Qty Atividade DisplayTotalWeeks</P><TABLE><TBODY><TR><TD>abr</TD><TD>1</TD><TD>446</TD><TD>9</TD></TR><TR><TD>abr</TD><TD>2</TD><TD>11</TD><TD>9</TD></TR><TR><TD>abr</TD><TD>3</TD><TD>1</TD><TD>9</TD></TR><TR><TD>abr</TD><TD>4</TD><TD>3</TD><TD>9</TD></TR><TR><TD>abr</TD><TD>5</TD><TD>1</TD><TD>9</TD></TR><TR><TD>mai</TD><TD>1</TD><TD>524</TD><TD>9</TD></TR><TR><TD>mai</TD><TD>2</TD><TD>701</TD><TD>9</TD></TR><TR><TD>mai</TD><TD>3</TD><TD>1</TD><TD>9</TD></TR><TR><TD>mai</TD><TD>4</TD><TD>2</TD><TD>9</TD></TR><TR><TD><STRONG>Grand Total</STRONG></TD><TD>&nbsp;</TD><TD><STRONG>1690</STRONG></TD><TD><STRONG>9</STRONG></TD></TR></TBODY></TABLE><P><SPAN>&nbsp;</SPAN></P><P><SPAN>I have stressed ChatGPT, but it doesn't give me what I'm looking for.</SPAN></P><P><SPAN>As an example, I have try this from GPT:<BR />TotalUniqueWeeks := COUNTROWS(SUMMARIZE('YourTable', 'YourTable'[SemanaMes]))<BR />DisplayTotalWeeks := CALCULATE([TotalUniqueWeeks], ALL('YourTable'))<BR />It doesn't return 9, that what I was expecting.</SPAN></P><P><SPAN>So, you are my last hope.<BR /></SPAN></P> Wed, 29 May 2024 00:45:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3956108#M153555 Anonymous 2024-05-29T00:45:14Z Re: Pivot Table Target Measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3956971#M153579 <P>Anonymous</a>&nbsp; Hi,&nbsp;you need to add another column to the TotalUniqueWeeks measure,&nbsp;Is this your desired outcome?</P><P><img /></P><P>&nbsp;</P> Wed, 29 May 2024 07:22:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3956971#M153579 DimaMD 2024-05-29T07:22:26Z Re: Pivot Table Target Measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3958191#M153604 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="312820" data-lia-user-login="DimaMD" class="lia-mention lia-mention-user">DimaMD</a>&nbsp;,</P><P>&nbsp;</P><P>I have had try that, but I got this one:</P><P><BR />Criada em (Month) | SemanaMes | Qty Atividade | measure 2</P><TABLE><TBODY><TR><TD>abr</TD><TD>1</TD><TD>446</TD><TD>5</TD></TR><TR><TD>abr</TD><TD>2</TD><TD>11</TD><TD>5</TD></TR><TR><TD>abr</TD><TD>3</TD><TD>1</TD><TD>5</TD></TR><TR><TD>abr</TD><TD>4</TD><TD>3</TD><TD>5</TD></TR><TR><TD>abr</TD><TD>5</TD><TD>1</TD><TD>5</TD></TR><TR><TD>mai</TD><TD>1</TD><TD>524</TD><TD>5</TD></TR><TR><TD>mai</TD><TD>2</TD><TD>701</TD><TD>5</TD></TR><TR><TD>mai</TD><TD>3</TD><TD>1</TD><TD>5</TD></TR><TR><TD>mai</TD><TD>4</TD><TD>2</TD><TD>5</TD></TR></TBODY></TABLE><P>Grand Total&nbsp;16905<BR /><BR /></P><P>Maybe the problem is here on calculated column:</P><P><!-- StartFragment --><SPAN class="">=</SPAN><SPAN class="">COUNTROWS</SPAN><SPAN class="">( </SPAN><SPAN class="">SUMMARIZE</SPAN><SPAN class="">(export_sensedata_atividades_2024_05_13;export_sensedata_atividades_2024_05_13[SemanaMes]))</SPAN><!-- EndFragment --></P><P><img /></P><P>&nbsp;</P><P>Before I forget:&nbsp;Slava Ukraini!!!</P> Wed, 29 May 2024 13:39:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3958191#M153604 Anonymous 2024-05-29T13:39:38Z Re: Pivot Table Target Measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3963305#M153750 <P>Anonymous</a>&nbsp;Hi, try it DAX, add in sumarize colum "<SPAN>Criada em (Month)</SPAN>"<BR /><BR /></P><LI-CODE lang="markup">=COUNTROWS( SUMMARIZE( export_sensedata_atividades_2024_05_13; export_sensedata_atividades_2024_05_13[SemanaMes]; export_sensedata_atividades_2024_05_13[Criada em (Month)] ) )</LI-CODE><P>&nbsp;</P> Fri, 31 May 2024 07:01:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3963305#M153750 DimaMD 2024-05-31T07:01:50Z Re: Pivot Table Target Measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3964527#M153785 <P>Hi Dima,</P><P>&nbsp;</P><P>I have try this before, and I believe that we are close because the result.<BR /><BR /></P><P>Criada em (Month) | SemanaMes | Qty Atividade | measure 2</P><TABLE><TBODY><TR><TD>abr</TD><TD>1</TD><TD>446</TD><TD>10</TD></TR><TR><TD>abr</TD><TD>2</TD><TD>11</TD><TD>10</TD></TR><TR><TD>abr</TD><TD>3</TD><TD>1</TD><TD>10</TD></TR><TR><TD>abr</TD><TD>4</TD><TD>3</TD><TD>10</TD></TR><TR><TD>abr</TD><TD>5</TD><TD>1</TD><TD>10</TD></TR><TR><TD>mai</TD><TD>1</TD><TD>524</TD><TD>10</TD></TR><TR><TD>mai</TD><TD>2</TD><TD>701</TD><TD>10</TD></TR><TR><TD>mai</TD><TD>3</TD><TD>1</TD><TD>10</TD></TR><TR><TD>mai</TD><TD>4</TD><TD>2</TD><TD>10</TD></TR></TBODY></TABLE><P>Grand Total&nbsp;16905</P><P>&nbsp;</P><P>Maybe on the measure now, because it must consider what is showed.</P> Fri, 31 May 2024 13:47:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pivot-Table-Target-Measure/m-p/3964527#M153785 Anonymous 2024-05-31T13:47:40Z