https://community.fabric.microsoft.com/t5/s/yrjkf47658/tracker sboinala Tracker Sat, 19 Sep 2026 04:15:32 GMT 2026-09-19T04:15:32Z https://community.fabric.microsoft.com/t5/Translated-Spanish-Desktop/Valores-de-recuento/m-p/997854#M9309 <P>La salida que estoy buscando es:</P><TABLE border="1"><TBODY><TR><TD>Gas &amp; Elec</TD><TD>3</TD></TR><TR><TD>Gas</TD><TD>2</TD></TR><TR><TD>Elec</TD><TD>1</TD></TR></TBODY></TABLE><P> </P><P>No conseguimos encontrar tu ubicación exacta.</P> Mon, 30 Mar 2020 07:07:53 GMT https://community.fabric.microsoft.com/t5/Translated-Spanish-Desktop/Valores-de-recuento/m-p/997854#M9309 sboinala 2020-03-30T07:07:53Z https://community.fabric.microsoft.com/t5/Desktop/Count-values/m-p/997853#M474169 <P>The output i am looking for is :</P><TABLE border="1"><TBODY><TR><TD>Gas &amp; Elec</TD><TD>3</TD></TR><TR><TD>Gas</TD><TD>2</TD></TR><TR><TD>Elec</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have tried the below ,however i couldnt get the first value&nbsp; Gas &amp; Elec</P> Mon, 30 Mar 2020 07:07:43 GMT https://community.fabric.microsoft.com/t5/Desktop/Count-values/m-p/997853#M474169 sboinala 2020-03-30T07:07:43Z https://community.fabric.microsoft.com/t5/Translated-Spanish-Desktop/Valores-de-recuento/m-p/997646#M9241 <P>Tengo dos mesas</P><TABLE border="1"><TBODY><TR><TD>Clientes</TD></TR><TR><TD>a</TD></TR><TR><TD>b</TD></TR><TR><TD>c</TD></TR><TR><TD>d</TD></TR><TR><TD>e</TD></TR><TR><TD>f</TD></TR></TBODY></TABLE><P> </P><P>Tipo de cuenta:</P><TABLE border="1"><TBODY><TR><TD>Cliente</TD><TD>Combustible</TD></TR><TR><TD>a</TD><TD>Gas</TD></TR><TR><TD>a</TD><TD>Elec</TD></TR><TR><TD>b</TD><TD>Gas</TD></TR><TR><TD>c</TD><TD>Gas</TD></TR><TR><TD>c</TD><TD>Elec</TD></TR><TR><TD>d</TD><TD>Gas</TD></TR><TR><TD>d</TD><TD>Elec</TD></TR><TR><TD>e</TD><TD>Elec</TD></TR><TR><TD>e</TD><TD>Elec</TD></TR><TR><TD>f</TD><TD>Gas</TD></TR><TR><TD>f</TD><TD>Gas</TD></TR></TBODY></TABLE><P> </P><P>Salida requerida</P><TABLE border="1"><TBODY><TR><TD>Cliente</TD><TD>Recuentos de gas y elec</TD><TD>Recuento de solo gas</TD><TD>Elec Only Count</TD></TR><TR><TD>a</TD><TD>1</TD><TD> </TD><TD> </TD></TR><TR><TD>b</TD><TD>0</TD><TD>1</TD><TD> </TD></TR><TR><TD>c</TD><TD>1</TD><TD> </TD><TD> </TD></TR><TR><TD>d</TD><TD>1</TD><TD> </TD><TD> </TD></TR><TR><TD>e</TD><TD>0</TD><TD> </TD><TD>1</TD></TR><TR><TD>f</TD><TD> </TD><TD>1</TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>La matriz de la visílacuo sería:</P><TABLE border="1"><TBODY><TR><TD>Recuentos de gas y elec</TD><TD>3</TD></TR><TR><TD>Recuentos de gases</TD><TD>2</TD></TR><TR><TD>Elec Counts</TD><TD>1</TD></TR></TBODY></TABLE> Mon, 30 Mar 2020 05:15:59 GMT https://community.fabric.microsoft.com/t5/Translated-Spanish-Desktop/Valores-de-recuento/m-p/997646#M9241 sboinala 2020-03-30T05:15:59Z https://community.fabric.microsoft.com/t5/Desktop/Count-values/m-p/997645#M474097 <P>I have two tables</P><TABLE border="1"><TBODY><TR><TD>Customers</TD></TR><TR><TD>a</TD></TR><TR><TD>b</TD></TR><TR><TD>c</TD></TR><TR><TD>d</TD></TR><TR><TD>e</TD></TR><TR><TD>f</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Account Type:</P><TABLE border="1"><TBODY><TR><TD>Customer</TD><TD>Fuel</TD></TR><TR><TD>a</TD><TD>Gas</TD></TR><TR><TD>a</TD><TD>Elec</TD></TR><TR><TD>b</TD><TD>Gas</TD></TR><TR><TD>c</TD><TD>Gas</TD></TR><TR><TD>c</TD><TD>Elec</TD></TR><TR><TD>d</TD><TD>Gas</TD></TR><TR><TD>d</TD><TD>Elec</TD></TR><TR><TD>e</TD><TD>Elec</TD></TR><TR><TD>e</TD><TD>Elec</TD></TR><TR><TD>f</TD><TD>Gas</TD></TR><TR><TD>f</TD><TD>Gas</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Required Output</P><TABLE border="1"><TBODY><TR><TD>Customer</TD><TD>Gas &amp; Elec Counts</TD><TD>Gas Only Count</TD><TD>Elec Only Count</TD></TR><TR><TD>a</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>b</TD><TD>0</TD><TD>1</TD><TD>&nbsp;</TD></TR><TR><TD>c</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>d</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>e</TD><TD>0</TD><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>f</TD><TD>&nbsp;</TD><TD>1</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The Visulation matrix would be :</P><TABLE border="1"><TBODY><TR><TD>Gas &amp; Elec Counts</TD><TD>3</TD></TR><TR><TD>Gas&nbsp; Counts</TD><TD>2</TD></TR><TR><TD>Elec Counts</TD><TD>1</TD></TR></TBODY></TABLE> Mon, 30 Mar 2020 05:15:49 GMT https://community.fabric.microsoft.com/t5/Desktop/Count-values/m-p/997645#M474097 sboinala 2020-03-30T05:15:49Z